Multiple View as Data Source

[kkmk]

Hi,

I want to export from multiple views in the same cube to a CSV file. Anybody can help me with the logic to achieve this?

Thanks
kkmk

[jim wood]

Create one standard process for exporting data from the cube. Within the process set a parameter for the view name. Then use within the process data source override (check out the reference guide) This way you can fire off the same process for multiple views. Obviously this is based on the views being in place already. If not create a process to create views against the cube then call the export process that I mentioned above for each of the views. Keep in mind you'll want to create the views on the prolog and call the process for each view on the epilog.

[kkmk]

Any sample processes to refer?

Thanks
kkmk

[jim wood]

I don't have exact examples of what I suggested. If you do a search for view creation on this forum you should be able to find a good starting point.

[tomok]

I want to export from multiple views in the same cube to a CSV file. Anybody can help me with the logic to achieve this?

In the same process? Can't be done. You'll have to run the process once for each view and then concatenate the files together with batch file command.

[kkmk]

Hi,

Thank you all for your suggestion and I have complete this task:

Work Note:

1. Written different process to export the view to CSV.
2. Create a bat file in the command prompt.
3. In the command prompt written copy command to append all the files.
Copy file1.csv + file2.csv + file3.csv finalfile.csv
4. Call this Bat from the TI process using ExecuteCommand.

Thanks
KKmk

[jim wood]

I'm glad you found a way round it and thanks for sharing your solution.