Page 1 of 1
Createing a Report for only approved Data
Posted: Thu Oct 31, 2019 10:48 am
by QFmbongwa
Hi I am new in tm1. I have "cube A" that has data and I have a TM1 application that is connected with "cube A", I would like to create Cube B that will get only approved data(approve in the application) from "Cube A". I would like to put data that has been approved in the tm1 application to Cube B and I would use Cube B as my data source for my reports. Please help
Re: Createing a Report for only approved Data
Posted: Thu Oct 31, 2019 7:20 pm
by tomok
QFmbongwa wrote: ↑Thu Oct 31, 2019 10:48 am
Hi I am new in tm1. I have "cube A" that has data and I have a TM1 application that is connected with "cube A", I would like to create Cube B that will get only approved data(approve in the application) from "Cube A". I would like to put data that has been approved in the tm1 application to Cube B and I would use Cube B as my data source for my reports. Please help
New to TM1? Nothing like jumping right into the deep end. Accomplishing what you want will require an understanding of TM1 applications work, how your approval hierarchy is setup and a complete understanding of rules and feeders.
When you create an application in TM1 you have to designate an approval hierarchy. This will result in a cube being created called }tp_application_state}{xxxxxxxxxx}, where xxxxxxx is a random string created by TM1. In this cube you will find a measure called “State” in which will contain a numeric value. A value of 4 in this element means it has been approved. So now, the trick is going to be writing a rule that populates cube B with data from cube A whenever the node has been approved:
Code: Select all
['Measure'] = N:IF(DB('tp_application_state}{xxxxxxxxxx}',!ApprovalDim) = 4,
DB('Cube A', !Dim1, !Dim2, !Dim3……!DimX),
0);
You'll also need to write feeders for Cube B. I'll leave that up to you. The code above is theoretical. I have no idea how many dimensions your cubes have nor their names. Also, the dimension containing the approval hierarchy will have to be in both Cube A and Cube B. Good luck.