TM1 Forum

Hi Team,

Would anyone be able to shed some insight into loading a cube "view" via a TI process?

I have a CSV file which I've brought into the TI process, and am trying to use a CELLPUTN to load the cube view, possible?.

Dimensions:
version
Currency
Years
Months
Company
Stores
Accounts
Measures


Prolog:
vCube = Stores
cview = Occupancy

Data:
CELLPUTN(v1, vCube, pVersion, vCurrency, vYear, '1', vCompany, 'Store 0001', '61000000-BASE RENT', 'Amount');
v1 = my $ amount
'1' = company

Thank you!

When loading a view via TI it has to be a public view. Within the data source tab you can select a cube view / subset as the source. If you select a source view it spools through the combinations set by the view in a similar way to comma delimited file. You map your variables in the same way. Be warned that you need to make sure all the dimensions within the view are constrained to only include the content you want, not just the dimensions that appear in the page area.

I hope that helps,

Jim.

jim wood wrote:When loading a view via TI it has to be a public view. Within the data source tab you can select a cube view / subset as the source. If you select a source view it spools through the combinations set by the view in a similar way to comma delimited file. You map your variables in the same way. Be warned that you need to make sure all the dimensions within the view are constrained to only include the content you want, not just the dimensions that appear in the page area.

I hope that helps,

Jim.

I think you misread the post Jim. Seems the OP is asking about loading from a CSV to a cube.

New2TM looks like you are on the right track. Just remember that when using CellPutN that all dimension element arguments must point to N elements. Your variables from the CSV should all be "other" and your CellPutN code on the Data tab.

lotsaram wrote:I think you misread the post Jim.

More than likely. At least the information may come in handy for them at some point.