Hi,
I have a Cube and need read this cube like a Data Source and insert the registers in a new cube with parameters inserts by users.
For example:
Cubo1
Dimension: Customer, Setor, Cust
in Dimension Customer have: "A"; "B", "C".
Now i need read this cube and insert only the information about the customer "A" in other CUBE (dimensions: Customer, Sales, Organization).
Users will include different entries in the field Customer (for parameters) .
Resume: Create a Process with parameters that read a Cube and insert in other Cube.
My problem is: How i can use a Parameters when I use DataSource = IBM COGNOS TM1
Thaks a lot!
Process with Parameters read Cube (Data Source)
-
andreborges
- Posts: 3
- Joined: Thu Jun 14, 2012 7:42 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
-
Duncan P
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Process with Parameters read Cube (Data Source)
If your cube is in the same TM1 server then you can do this with not much trouble.
Firstly you need a view defined on the cube. If you don't have one you can create it in the prolog with the appropriate TI commands, and you could make its definition depend on process parameters as well.
In the prolog you need to set DatasourceNameForServer to the name of the cube, DatasourceType to 'VIEW' and DatasourceCubeView to the name of the view.
Your process must be initially created by using a cube as a datasource. What we do is to have a dummy single cell cube with as many dummy dimensions as we will ever need (I use 20) and use that as the source. This will set up a set of variables which will get populated with the dimension coordinates from the cube you choose. Any spare variables will be ignored. The actual data values will be in either NValue or SValue. You can examine Value_Is_String to determine which.
Firstly you need a view defined on the cube. If you don't have one you can create it in the prolog with the appropriate TI commands, and you could make its definition depend on process parameters as well.
In the prolog you need to set DatasourceNameForServer to the name of the cube, DatasourceType to 'VIEW' and DatasourceCubeView to the name of the view.
Your process must be initially created by using a cube as a datasource. What we do is to have a dummy single cell cube with as many dummy dimensions as we will ever need (I use 20) and use that as the source. This will set up a set of variables which will get populated with the dimension coordinates from the cube you choose. Any spare variables will be ignored. The actual data values will be in either NValue or SValue. You can examine Value_Is_String to determine which.