i want to load data into a cube using two parameters.
id name service department data
these all are col. in my .csv source file.i want two parameters service and department based on those 2 only data should be loaded.
i never used parameters before.please someone help me.
loading data using parameters
-
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: loading data using parameters
Hello,
If I understand your post correctly, you want to load data from a CSV file with two columns which are "Service" & "Department".
To do this you need to set the CSV file as your data source, then look at the variables tab to configure your CSV columns not paramaters.
In the image below the two variables will present once for each row from the CSV in the Metadata & data tabs which is where you make dimensional changes and put data in your cube.
Parameters can be used to load data but generally where a specific piece of data is passed from a user interface or another TI process.
Hope this helps.
If I understand your post correctly, you want to load data from a CSV file with two columns which are "Service" & "Department".
To do this you need to set the CSV file as your data source, then look at the variables tab to configure your CSV columns not paramaters.
In the image below the two variables will present once for each row from the CSV in the Metadata & data tabs which is where you make dimensional changes and put data in your cube.
Parameters can be used to load data but generally where a specific piece of data is passed from a user interface or another TI process.
Hope this helps.
-
- Posts: 10
- Joined: Mon Sep 18, 2017 9:12 am
- OLAP Product: tm1
- Version: 10.2.2
- Excel Version: 2010
Re: loading data using parameters
i want to use parameters as whenever i should run tI process it should ask for what service and what department i want to insert data. it should load data only for specified service and department.
-
- Regular Participant
- Posts: 173
- Joined: Sat Mar 20, 2010 3:03 pm
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007-10
Re: loading data using parameters
OK
Create two parameters:-
CellPut?(YourDataValue, psService, psDepartment)
I Assume that you will read the data values from your CSV
Create two parameters:-
- psService
- psDepartment
CellPut?(YourDataValue, psService, psDepartment)
I Assume that you will read the data values from your CSV