TM1 Forum

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 includ...

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. :oops: No we just load the new...

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 ...

Thank you for your reply. Your right, if I change the rule to be on the leaf elements only, "NB Profit and "NB Profit before Comm and Expenses" has the same value but unfortunately it doesn't give me the right answer
Any ideas?
Andrea

Hi there I have a problem with feeders. I have two cubes, Rpt_Earnings Cube and Reporting Cube. Now Rpt_Earnings is populated by DB rules from the Reporting Cube. In my Rpt_Earnings Cube I have dimensions : Biz_line, Company, Lob_Type, Period, Reporting Version, Source, Tax_fund, Valuation, Version,...

Thanks for reply's! I found the problem in on of my dimensions, for some reason there was a duplication in the dimension which caused the amounts to duplicate in the cube.

Thanks again!

Hi there Hope somebody can help me with my problem. The problem that I have is that the amounts in a cube is duplicated after loading the cube from a TI process. The TI process is getting the data from SQL server. The Data Action is set to Accumulate Values. I have tested the SQL Data as well to see...

Thanks!!! Sorry for the late reply!

Hi there

Does anybody know what is the custom format in a cube viewer to show a million format?

For example : If I have the amount R60 000 000, I want to format the abount so that it shows R60.
I have used 0, as the format but it doesn't work? All I get is 60000.

Thanks.
Andrea