TM1 Forum

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.

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.

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.

OK
Create two parameters:-

• psService
• psDepartment

Then in your code
CellPut?(YourDataValue, psService, psDepartment)

I Assume that you will read the data values from your CSV