Search found 2895 matches

by lotsaram
Sun Nov 12, 2017 10:17 am
Forum: Cognos TM1
Topic: DimensionElementDelete deleting alternate elements
Replies: 6
Views: 443

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: 192

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: 262

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: 11
Views: 332

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: 234

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: 170

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: 190

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: 147

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: 370

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: 807

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: 16765

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: 235

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: 257

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: 196

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: 444

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: 485

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...
by lotsaram
Thu Sep 21, 2017 6:22 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: 485

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

we are using these functions in Prolog ViewExtractSkipCalcsSet( pCube, cTempViewTo, 0 ); ViewExtractSkipRuleValuesSet( pCube, cTempViewTo, 0 ); ViewExtractSkipZeroesSet( pCube, cTempViewTo, 0 ); My oh my. And how many dimensions does the cube have? And how long does the process take?
by lotsaram
Sat Sep 16, 2017 8:38 pm
Forum: Cognos TM1
Topic: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect
Replies: 8
Views: 410

Re: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect

I went through the post and reached the documentation. Thank you for that. Are you saying the only way to create this type of hierarchy is to do it through code on the Advanced tab? In other words, TM1 Architect cannot naturally handle it by, for example, method of importing/loading data and throug...
by lotsaram
Sat Sep 16, 2017 8:59 am
Forum: Cognos TM1
Topic: Creating Cube Generates "Cell type is string" error
Replies: 9
Views: 347

Re: Creating Cube Generates "Cell type is string" error

Let's give Alan a break from replying to you or I fear he may blow a gasket. First let's go back to square 1. In TM1 all dimensions are equal. There is no special treatment for time or measure dimensions. In the cube properties you can assign a dimension as the measure dimension. But this is just fo...
by lotsaram
Thu Sep 14, 2017 7:17 pm
Forum: Cognos TM1
Topic: TM1 License Question
Replies: 3
Views: 235

Re: TM1 License Question

As far as I am aware the web tier has never contributed to PVU.

(Except for the kinda restriction of Express licensing which is limited to single box install formerly of max 32 cores then changed to max 1600 PVU).