Metrics universe with SAP BI

[former_member199503]

Can they be generated metric from SAP BI in BOBJ XI 3.1 Dashbord Builder?

If it is like that, since I generate the filter of dates for the indicator?

Thanks

[former_member199503]

Thanks

[IngoH]

Hi,

not 100% sure on what exactly you trying to do but right now you can not have metrics based on an OLAP Universe. there are several analytics - like gauges - that are able to leverage OLAP Universes.

ingo

[former_member199503]

Thnaks,

But I need to fill the analytical metrics in DM, but not how to generate the restriction of the period indicated.

SQL would be:

date between @ Prompt ( 'BEGIN_DATE', 'D',, mono, free) and @ Prompt ( 'END_DATE', 'D',, mono, free)

but in the BW OLAP universe?

[Former Member]

HI,

It is possible to create a filter on OLAP universe using @Prompt.

Here is a sample based on Calendar day that let you select a start date and an end date.

<FILTER KEY="@Select(Calendar Day\Level 01 Calendar Day).[TECH_NAME]"><CONDITION OPERATORCONDITION="Between">
<CONSTANT TECH_NAME="@Prompt('Start date','D','Calendar Day\Level 01 Calendar Day',Mono,Primary_Key,Not_Persistent)"></CONSTANT>
<CONSTANT TECH_NAME="@Prompt('End date','D','Calendar Day\Level 01 Calendar Day',Mono,Primary_Key,Not_Persistent)"></CONSTANT></CONDITION></FILTER>

By the way I recommend that you can also create a variable: the main difference is that the SAP variable is mandatory whereas the filter can be selected on demand.

Didier