TM1 Forum

Hi

I'm pretty new to TM1, so it maybe the very basic question.

I have a Balance sheet cube with dimensions as LOB, Region, GLAccount, Costcenter, GLSummaryBalance.

My LOB dimension has LOBNr and LOB description concatenated.
Region dimension structure is region number and region name concatenated
Costcenter dimension is LOBNr, RegionNr and costcenter concatenated.

When I chose my LOBNr as 10, then I want the region dimension to show only the regions that belong to LOB 10.

Please help...

Thanks
Aparna

Please read this ,It might be of help

http://www.ibm.com/support/knowledgecen ... 00123.html
https://everanalytics.wordpress.com/201 ... ognos-tm1/ Thanks

You need to create cascading attributes on each dimension and then create a 2-dimensional cube, one of them being }Clients dimension and then in the websheet, write DBSS formulas to store the selected let`s say LOBNr to the 2-dimensional cube. Then for the Region Dimension, use an MDX subset that filters out only the Regions with the Attribute LOBNr = StoredValueOfLOBNr

Thank you for giving me a very quick response.

I do not want to create the picklists for this particular scenario. I was wondering if there is a way that I could just use the dimensions functionality to achieve this.

Thanks,
Aparna

Ardi

Would you mind giving screenshots of your suggestion if you have them please.

Thanks
Aparna