Product view depending on different date

[afullex]

I have a Cube called Rpt Earnings, from this cube I have to build a view in Cube Viewer which consist of the products and the appropriate measure. The cube consists of a Biz_Line, Valuation, Period, Company and measures dimension. The different products is in the Biz_Line. There are two hierarchies in the Biz_Line Dimension: Open Business and Closed Business with the appropriate products underneath.

The problem I’m having is that depending on the Valuation some products will move from Open Business to Closed Business.
For instance Structured Endowments and Guaranteed Endowments was in the F201212 Valuation, Open business but for the F201306 Valuation it is Closed Business. I have created the Biz_Line dimension like the F201212 view below . The View will work if I select Valuation F201212 but the F201306 Valuation will not be correct.
[img]

View Example.JPG (52.63 KiB) Viewed 4351 times

[/img]

I have considerate a lookup cube but any other suggestions on how to solve this issue will be greatly appreciated.

Thanks,
Andrea

Operating system: Windows XP
TM1 version: 9.5.1 (TM1 Architect)
Excel Version: 2007

[Paul Segal]

Have you considered splitting the Open Business and Closed Business into a separate dimension? You could then set a attribute flag and load into one or the other dependent on that. Unless you reload everything all the time, this would preserve the history in the right place.

[afullex]

Thank you Paul for the quick response.
Do you mean that I create a Dimension with Open Business and Closed Business as elements and then set a attribute for each product? I am sorry for asking but I am struggling to get to grips with the whole attribute factor as well.

No we just load the new Valuation not the historical ones.

Kind Regards,
Andrea

[Paul Segal]

Yes, so your dimension would be

N Open Business
N Closed Business
C All Business (if you want it)

Then create an numeric attribute on the dimension, such as ClosedFlag, where 0 = Open and 1 = Closed. You can then reference this when you upload the data against each product so that it loads to the correct element. I'm assuming you know if a product is open or closed before you upload the data. If you don't, you could load it all to open business initially and then move the relevant product data to closed business using a TI process based on the ClosedFlag and the period.

[afullex]

Thanks Paul and sorry for the late reply. I get what you are suggesting but will it work if the Rpt Earnings cube is a virtual cube that receives all the data via DB rules and is not loaded with a TI process. The Source cube is loaded with a TI process but hasn’t got the Open/Closed Dimension included.

I think I should then recreate the source cube with the Open/Closed Dimension?

[Paul Segal]

You don't need to alter your source. One way to do it is to create a 2d lookup cube, with the product and time dimensions, and then reference that with IF statements in the rules when you are populating the Rpt Earnings cube deom the source cube.