Export SQL queries used in power play cubes

[vinoth]

Hi,
Though we were able to see the SQL queries in the SQL tab while publishing the cubes. But once published, we are unable to view the SQL queries.

1. I wanted to know is there any viewing option to see the SQL queries in cubes.
2. Is there any option to export the SQL queries from the cubes.


Cheers !!!
Vinoth Selvam

[cognostechie]

You cannot see the SQL queries while publishing the cubes. You can see it in the Data Source option inside Transformer.

I don't understand why would you want to see the SQL queries after the cube is published? What's the purpose here?

Once the cube is built. the data is transformed from relational format to dimensional format. It does not remain in the format you would conclude by looking at the SQL queries.