Fix structure in web intelligence or crystal reports

[Former Member]

Hello everybody,

I got a question referring to webI respectively crystal reports. Is it possible to build a fix row/(column) structure?

For example: The user provides a month and year. And i want to create a report with sales for this month (first row), the sales for january to the selected month (1 to selected month, in row 2) and the sales from the last year (selected year - 1).

Is it possible to define such a structure in Webi/CR and to reuse it in several reports?

Thank you very much!

Sebastian

[Henry_Banks · Accepted solution]

Hi,

BW customers tend to consume Characteristic or Key Figure Structures from BEx Query designer.

Regards,

H

[Former Member · Accepted solution]

Hello Henry,

thank you for your response. I know that it is possible to define such structures in the query designer, creating an universe accessing these query and use it in WebI.

But if i want to access the query directly without creating an universe?

Regards,

Sebastian

[Henry_Banks · Accepted solution]

Direct Bex query access is possible in BI4.0 However, the structure is still defined in bex query.

the concept of reusuable global structures doesn't exist in Business Objects / Crystal,  apart from Layout Templates like CSS files.  (but this doesn't model data for you, only formatting layout) 

Regards,
H