Hello all,
When I create a Crystal XI document based on universe measures and dimensions, the Crystal XI tool displays a Query Panel similar to Webi, which allows selecting which measures and dimensions are going to be used in the query.
Then using the Crystal SDK for Java or .NET, I can open the document, and iterate on the database tables (a command table in this case) and retrieve the SQL text of the query.
Do you know how to retrieve the name of the measures or dimensions that were used also ?
Or does Crystal only store the SQL text of the universe query?
Thanks
Olivier
When I create a Crystal XI document based on universe measures and dimensions, the Crystal XI tool displays a Query Panel similar to Webi, which allows selecting which measures and dimensions are going to be used in the query.
Then using the Crystal SDK for Java or .NET, I can open the document, and iterate on the database tables (a command table in this case) and retrieve the SQL text of the query.
Do you know how to retrieve the name of the measures or dimensions that were used also ?
Or does Crystal only store the SQL text of the universe query?
Thanks
Olivier