Search found 2899 matches

by lotsaram
Thu Dec 14, 2017 3:26 pm
Forum: Cognos TM1
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 395

Re: Change in Element Name of a frequently used Dimension

You don't need to reload all data. Or even reload any data. Just change one arbitrary cell value will do (and then change it back again if you like). All that's needed is to force the server to see a data change as this will force the cube to be saved to disk on next save data. And yes find replace ...
by lotsaram
Thu Dec 14, 2017 10:47 am
Forum: Cognos TM1
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 395

Re: Change in Element Name of a frequently used Dimension

The main thing to note here is that there is a potential for data loss *if the alias used for the swap is deleted* This is because TM1 won't recognize any change to cube data as a result of the dimension change (and really why should it). But within all the cube files in the file system the data is ...
by lotsaram
Mon Dec 11, 2017 8:06 am
Forum: Cognos TM1
Topic: Anyway to prevent Files to Accidentally DBSW ?
Replies: 8
Views: 275

Re: Anyway to prevent Files to Accidentally DBSW ?

DBS, DBSS, DBSW formulas are a bit of a hanglover from the 80s & 90s. Back in the days when TM1 didn't have any ETL capability this was the only way to send data to the TM1 database. These days they aren't used that much. Why is TM1 using the F9 to send? the F9 serves its own purposes and that it to...
by lotsaram
Wed Dec 06, 2017 9:40 am
Forum: Cognos TM1
Topic: MDX to Filter on Numeric Attribute
Replies: 6
Views: 166

Re: MDX to Filter on Numeric Attribute

Hey George this looks a lot like a PMR which I had open. 89862,112,848 "Inconsistent behavior in TM1 MDX evaluation" There are 3 ways which TM1 allows attributes to be queried via MDX which deliver inconsistent results. TM1 allows both string and numeric attributes 1/ TM1 "shorthand" MDX notation e....
by lotsaram
Sun Nov 12, 2017 10:17 am
Forum: Cognos TM1
Topic: DimensionElementDelete deleting alternate elements
Replies: 6
Views: 542

Re: DimensionElementDelete deleting alternate elements

Moh wrote:
Sat Nov 11, 2017 1:08 pm
paul pls give the final code you used,it will help me
There is actually a free utility available called TI Helper which can inject TI code snippets into the architect/perspectives process editor. Reverse dimension while loop is one of the included snippets.
by lotsaram
Mon Nov 06, 2017 9:32 pm
Forum: Cognos TM1
Topic: Custom Rollup Issue
Replies: 2
Views: 225

Re: Custom Rollup Issue

Hello, I am running into an issue with the user created custom rollups. When users add a custom rollup to the cube view, they do not see any consolidated data there, though they have write access to all leaf elements in the rollup, and all elements' data is loaded, no rules. An admin can see totals...
by lotsaram
Thu Nov 02, 2017 3:30 pm
Forum: Cognos TM1
Topic: static subsets saved disappears
Replies: 6
Views: 315

Re: static subsets saved disappears

Thats the code we have . Are you sure? Like really, REALLY sure? Because if elements are being removed from a static subset (which isn't being edited in any way), then the only way that is happening is if the elements are being deleted and then re-added to the dimension. Have you double (and triple...
by lotsaram
Thu Nov 02, 2017 3:25 pm
Forum: Cognos TM1
Topic: DimensionSecurity Rules not being fired
Replies: 14
Views: 485

Re: DimensionSecurity Rules not being fired

The problem is that if I delete the Rules and also I delete the }DimensionSecurity cube from my model, then non-admin users cannot open any of the cube views, so I need to populate the }DimensionSecurity somehow. I know I can write a TI process to populate that cube, but I don't understand why the ...
by lotsaram
Wed Nov 01, 2017 3:21 pm
Forum: Cognos TM1
Topic: Problem after upgrading from TM1 10.2.2 to 10.3
Replies: 3
Views: 275

Re: Problem after upgrading from TM1 10.2.2 to 10.3

We have recently upgraded from TM1 10.2.2 to TM1 10.3 What exactly do you mean by TM1 10.3? As far as I am aware no such version exists. "10.3" was used to refer to the server version of the 1st iteration of Planning Analytics cloud and AFAIK exist only in the cloud version and is not available on ...
by lotsaram
Mon Oct 30, 2017 8:45 pm
Forum: Cognos TM1
Topic: Changing data on server re-boot
Replies: 4
Views: 199

Re: Changing data on server re-boot

we are on fix pack 5 10.2.20500.75 We have data on an employee record that is being cleared only when the server is re-booted. The version you are on is affected by APAR PI70620 where feeders can delete entry data. This was discussed already in this thread . I suggest you check the test case and se...
by lotsaram
Sun Oct 29, 2017 4:07 pm
Forum: Cognos TM1
Topic: Can feeders delete data from the cube!?!?!?
Replies: 2
Views: 215

Re: Can feeders delete data from the cube!?!?!?

You have given too much pseudo code and not enough information. However it sounds similar to APAR PI70620 which was a defect where if there was overfeeding where an input cell was fed (i.e. data entry cell with no rule or rule evaluating to STET) then the input data would be deleted on server restar...
by lotsaram
Tue Oct 24, 2017 8:59 am
Forum: Cognos TM1
Topic: Create a drillable consolidator with only leaf level children
Replies: 5
Views: 186

Re: Create a drillable consolidator with only leaf level children

I'm trying to create a dynamic subset that shows a collapsed consolidated node that when expanded, only shows the leaf level children (not any consolidated children). Does anyone have any hints? You could achieve this with separate subsets (e.g. a "summary" subset and a "drilled" subset) but it isn...
by lotsaram
Thu Oct 19, 2017 5:32 pm
Forum: Cognos TM1
Topic: Adding a subset to a dbrw
Replies: 7
Views: 429

Re: Adding a subset to a dbrw

Analytics123 wrote:
Thu Oct 19, 2017 5:02 pm
I have a subset that refreshes nightly .

Is there a way i can refer that subset in a dbrw to retrieve cube value .

Thanks,
Is this even a serious question?
What is stopping you doing this?
Have you tried it?
by lotsaram
Tue Oct 17, 2017 5:18 pm
Forum: Cognos TM1
Topic: Direct edit dimension collection has not been cleared before commit
Replies: 6
Views: 908

Re: Direct edit dimension collection has not been cleared before commit

By way of update support opened a collab with development on this error and it seems that IBM development believe the error message is caused by an empty subset or UDC at the time the dimension is updated. Thus can be filed into the category of "not really an error".
by lotsaram
Mon Oct 02, 2017 7:46 am
Forum: Cognos TM1
Topic: Fix Pack Releases: 10.2 Series
Replies: 45
Views: 17263

Re: Fix Pack Releases: 10.2 Series

Not sure if others have noticed this but a defect notice for FP7 IF5 in IBM's notifications last week
Troubleshooting: PI87752: PROPORTIONAL SPREAD CAUSES MEMORY LEAK SINCE FP7 IF5 : MEMORY CONSUMPTION EXPLODES AND NEVER ENDS
by lotsaram
Fri Sep 29, 2017 3:20 pm
Forum: Cognos TM1
Topic: Average and Average ifs excel function in tm1
Replies: 4
Views: 267

Re: Average and Average ifs excel function in tm1

so what's the question?
by lotsaram
Fri Sep 29, 2017 8:07 am
Forum: Cognos TM1
Topic: Active Forms using multiple cubes
Replies: 5
Views: 290

Re: Active Forms using multiple cubes

Could you give me an idea of what the MDX statement would look like and where I would need to utilize it? You are unlikely to get a meaningful response which is specific enough to help you until you do your bit and provide enough information to make such a response possible. Look at the RFA for a g...
by lotsaram
Tue Sep 26, 2017 4:27 am
Forum: Cognos TM1
Topic: Elements of dimension on perspectives
Replies: 2
Views: 223

Re: Elements of dimension on perspectives

Hi all, I would like to list all elements of the dimension of control }Cubes of my model on perspecitves. Does anyone know how to do this? I tried the DBRW, but this case it is different because is not the cube. Thanks in advance, JR All you need for this is the Excel TM1 function DIMNM. Combined w...
by lotsaram
Mon Sep 25, 2017 3:38 pm
Forum: Cognos TM1
Topic: Message on TM1 Web
Replies: 6
Views: 496

Re: Message on TM1 Web

If you make a TI that returns an error when it finds that the active user does not have access, then you can set you message in the error section of the button. Assuming they do have access, then the TI will not error and they continue as befoe to the form. Hope that makes sense. +1 This is a great...
by lotsaram
Fri Sep 22, 2017 1:53 pm
Forum: Cognos TM1
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 676

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi qml/Wim, thank you for your suggestion. we are using ViewExtractSkipRuleValuesSet( pCube, cTempViewFrom, 0 ); in prolog ,but still data is not copied to some of the cells in target version. attached my TI Process code. Regards, Rajesh Dayaneni This is a mash up of a bedrock copy process. Why not...