TI to Fill TM1 Cube with Dummy Values
This article is about a TI to fill TM1 cube with dummy values. From time to time you may require some dummy data in your cube so that you can do full fledged testing of your rules and consolidations.
A TM1 consultant Rahul Parashar has submitted a turbo integrator process which does just that. Here are the details of the process:
This process fills the cube with random values for a specific dimension/subset intersection.
pCubeName – Name of the cube
I1, I2, I3 etc – Here you can do 3 things.
- You can leave the parameter as it is (ALL). This will consider all items of that dimension.
- You can write specific item name. This will consider only that particular item and will fill random/dummy values only for that item.
- You can mention subset name of a dimension. If subset exists, this will consider all items that are present in that subset.
NOTE: If you supply such a subset name which is also a dimension element name, process will fill dummy values only in dimension element (to be on the safer side)
pZeroOut – Inputting 0 will fill dummy values whereas inputting pZeroOut = 1 will zero out the cube for same intersection
Let’s say I have a cube called Sales with 5 dimension: Products, Cities, Months, Versions and Measure in that order. I want to fill dummy values for Sales Quantity (measure dimension item) in all products, a subset of cities called AsiaSubset, only in Budget Version 1 in all months.
I’ll supply following parameters in the TI process:
pCubeName : Sales
I1 : ALL
I2 : AsiaSubset
I3 : ALL
I4 : Budget Version 1
I5 : Sales Quantity
I’ll leave I6 to I16 as it is and
pZeroOut : 0
As the TI runs, it will complete successfully and fill the cube with dummy values if all the mentioned items are present in the dimensions.
You can subscribe to our website and download the TI. Subscribe and get all such new objects and tools on e-mail.