Skip to Content
0
Apr 27, 2009 at 05:18 PM

View Structure ELEMENTS of BW Query in the Field Explorer of Crystal

35 Views

Background:

Looking for some help from Crystal gurus...I have worked with Cognos in the past on top of SAP BW. (i.e. using BW queries as a semantic layer to generate deep MDX and retrieve information from the BW database server)

I am now attempting the same with BO Crystal reports. There are a couple different ways you can make a connection with a BW Query from Crystal Reports: (1) SAP Query ; (2) SAP MDX BW Query. I am using the latter, because it is suppossed to have more flexibility on Crystal front end to slice data in different ways.

My problem:

When I import the query and view the fields in "Field Explorer" of Crystal, I can see all the elements of my query except for the structure elements. I can see the Structure itself, but NOT the actual structure ELEMENTS of it.

There should be a way to do this, because I don't necessarily want to report all of my structure elements that I define in a query. The only way I can filter certain elements is by filtering the entire report (i.e. "Select Expert") --> which is not useful because I need to be able to use structure elements in different places of the report withOUT having to report everything in the structure each time.

I hope this makes sense....cheers and points for any help provided.

- BJ