TM1 Forum

Hi Gareth, the file is no longer available. pls help

How to use a single value prompt filter in a report(list and crosstab) that uses a package having two cubes.
Please help..tnx in advance!

by the way, im using macros to login to COGNOS BI(Xcelerator).

my login and logout macros in COGNOS TM1 were not functioning in COGNOS BI.
Is there anyone knows how to fix this?
It would be a great help..
thanks in advance..

Please use this image as your reference..

Hope it helps.

Thank you.

regards,


JR

In TM1, when it comes to adding or subtracting, we must use the logic of hierarchy of elements. In this, associates the relationship of Parents and children. In your case, you can use this hierarchy: Sum 1+2 = Consolidated Element, Parent of Car 1 and Car 2 elements Sum 3+4 = Consolidated Element, P...

For me, my idea is to use the vba macro of Excel to list down all the elements of a dimension in an excel sheet. 1.First, get the no. of elements or size of a particular dimension that you want to use. Dim x as long x = Application.Run("DIMSIZ" ...etc 2.Second, use DIMNM to get the element...