Search found 2887 matches

by lotsaram
Thu Oct 19, 2017 5:32 pm
Forum: Cognos TM1
Topic: Adding a subset to a dbrw
Replies: 4
Views: 90

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

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

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

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

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

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

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

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

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

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

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

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).
by lotsaram
Wed Sep 13, 2017 11:35 am
Forum: Cognos TM1
Topic: TI Process Doubling Elements?
Replies: 4
Views: 214

Re: TI Process Doubling Elements?

You might want to check the order of your parameters in your DIMIX. Lovey's not going to be too happy. 2nd that. Your DIMIX as written will return 0 100% of the time. You can't have an element in a single consolidation more than once, do you mean that the extant elements exist in their original loc...
by lotsaram
Wed Sep 06, 2017 9:38 am
Forum: Cognos TM1
Topic: Rule
Replies: 3
Views: 185

Re: Rule

Check your syntax on this rule. The proper syntax when using DB to reference a cube is: DB('Name of Cube', Dim1, Dim2, Dim3....Dimx) Yes. Although it would be a pretty decent enhancement if you could use a blank string as the first argument in a DB() to mean "Me. The cube that I'm in" the same way ...
by lotsaram
Wed Sep 06, 2017 7:26 am
Forum: Cognos TM1
Topic: Seeking idea for users management in multiple instances
Replies: 7
Views: 350

Re: Seeking idea for users management in multiple instances

You are talking about a business application designed to manage users and security across multiple TM1 instances. You can build your own application for this, and many larger TM1 shops certainly have. However if you want a OOTB solution to just drop in then commercial products typically have a price...
by lotsaram
Fri Sep 01, 2017 4:09 pm
Forum: Cognos TM1
Topic: Tm1 public subsets gets cleared
Replies: 5
Views: 290

Re: Tm1 public subsets gets cleared

If subsets are "getting cleared" then it's because elements are being deleted and added back to the dimension. To avoid this unwind the dimension rather than deleting elements. There are plenty of topics you can find on unwinding dimensions.
by lotsaram
Fri Sep 01, 2017 6:22 am
Forum: Cognos TM1
Topic: How to get an automatic cubeview refresh with TI Process
Replies: 5
Views: 180

Re: How to get an automatic cubeview refresh with TI Process

The CLIENT is independent of the SERVER. Client requests data, server responds and sends data, client renders data for viewing. And that is how it stays until the client makes another request. Any "automatic refresh" needs to be triggered from the client side. What you want is achievable in Excel (w...
by lotsaram
Thu Aug 31, 2017 12:18 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 359

Re: ASCIIOUTPUT to csv to show data in different columns

Well you are stuck my friend as TM1 only provides the local variables DatasourceASCIIDelimiter & DatasourceASCIIQuoteCharacter which apply to BOTH the text file being read AND the text file(s) being exported. You would think it would be sensible to have separate variables but fact is we don't. So t...
by lotsaram
Wed Aug 30, 2017 4:41 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 359

Re: ASCIIOUTPUT to csv to show data in different columns

Correct, either you use Expand like Lotsaram shows you, either you use the concatenation operator ( | ) to string the data together. Make sure that your numeric values are exported correctly too, if applicable. That's actually a hidden benefit of Expand ;) all variables are treated as string even t...
by lotsaram
Wed Aug 30, 2017 1:30 pm
Forum: Cognos TM1
Topic: ASCIIOUTPUT to csv to show data in different columns
Replies: 14
Views: 359

Re: ASCIIOUTPUT to csv to show data in different columns

That's correct Wim. Is there a way to change the delimiter for export? Well you are stuck my friend as TM1 only provides the local variables DatasourceASCIIDelimiter & DatasourceASCIIQuoteCharacter which apply to BOTH the text file being read AND the text file(s) being exported. You would think it ...