Filtering on Dimensions

[achallapalli]

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

[BariAbdul]

Please read this ,It might be of help

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

[ardi]

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

[achallapalli]

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

[achallapalli]

Ardi

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

Thanks
Aparna