Skip to Content
avatar image
Former Member

Is it possible to use VC to also create queries from Info Cubes?

Hello,

Is it possible to use VC to also create queries from Info Cubes from scratch or they must exist beforehand and VC knows only to retrieve their data?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 20, 2007 at 10:06 PM

    You can do that but then you need to use the XMLA connection to the BW and click on the $INFOCUBE-node in the list of queries. By opening this node (which might take some time, depending on how many cubes you have active in your system), you can then create an MDX-query on the cube(!).

    But this query will not be saved back in the BI, it will just be saved (the MDX statement) in the VC model.

    If you want to to create a BI query and have it stored in the BI system, you need to use the BEx QueryDesigner.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      After you created such a query, you can always manually change the MDX statement with the query editor (right mouse click on the query on the story board).

      There were discussions about that but things are changing very dynamically, so I cannot say myself what is planned for future releases.