Webi 4.0 - Prompts - Runtime сalculation default values. Is it possible?

[Former Member]

BI 4.0 SP6

I want to set default date values in prompts - between from and to.

Values must be calculated. Formulas:

1. Date From = CurrentDate - 7 days

2. Date To      = CurrentDate + 7 days

It's very popular requirements from report users.

In other BI tools (non-sap), it's no problem with it. But not in Webi...

I can't find the way to do this in Webi....  Only manual static values....  In Crystal for enterprise - you can (using interactive Filters - and using formulas on default values).

Is it possible in Webi somehow or not ?

[Former Member]

Unfortunately my team still haven't any workarounds on missed basic functionality - prompts default values.  Very child limitation, but very painful.

Ability to using functions/calculations in @prompt default value parameter on Semantic Layer (IDT)

@Prompt('Enter value(s) for Something:', 'A', 'Class\Something', Mono, Free, Persistent, {sysdate - 14} )

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=E445BDF0-DEF5-4D6A-8A1D-519A4D301682&idea_id=8D91ED5D-...

[Former Member]

And another  - with similar  problem in IDT.

IDT - BL Set Parameter default value(-s) by formula - Like in CR4E

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=E445BDF0-DEF5-4D6A-8A1D-519A4D301682&idea_id=1918147C-...

[Former Member]

Open idea for this - please vote.

https://ideas.sap.com/ct/ct_a_view_idea.bix?c=1DA84A30-1E5A-43FA-95C5-857A8B99D197&idea_id=161A4002-...

[MartinMaruskin]

Hi Mikhail,

in case you have webi based on top of BEx query. In BEx query you can create Bex variables having default values popped on report's selection screen?

Aren't Bex variable available on webi's prompts?

it is just an idea I'm no sure if webi is capable of this.

Cheers,

m./

[former_member189638]

You need to create 2 Objects in the Universe

Object1= Date + 7

Object1= Date - 7

Now in the WebI report, drag the Sales Date ..Select the Operator as between..Then select Object1 and Object2..

[Former Member]

No, don't ever think about webi based on top of BEx queryBex on BO. (It's evil- no ability for drills  , slow, etc).

This universe based on classical relation DBMS

[Former Member]

And i get Default values on Prompt window  popup  and then have able to change with date prompt?

Are you shore ?

[former_member189638]

oh! you want to display the value as well..hmm..that is not possible with the above method.

[former_member189638]

Did you try creating objects in Universe using the prompt function and default value in it??

Something like below. You might need to tweak this a bit as I don't have access to my system right now and have not tested it.

@Prompt('Select the Date:','D',,mono,constrained,persistent,{'(DATE) -7'})

[Former Member]

Yes, display value - "You propose to user interval of dates (from and to), user can agree with them (mostly) - but if he wants other - he can change and choose dates by your self (in promts)".

It's basic BI feature, not something special. 

In BW you can easly do this with  on BEx-User Exit variables (using I_STEPS and some ABAP-coding).

[former_member189638]

You cannot do it at WebI level....But you can definitely do it at universe level. Please check the below thread on how to do at Universe level. You can create 2 objects using the formula Date-7 and Date + 7 respectively and use it in Webi report.

http://scn.sap.com/thread/3359877

Incase you are using SAP BW as backend then create 2 user exit variables at the BW end.

[Former Member]

No, not help. I can't use select value both types at the same type - from prompt and from object in this query.

Again, what i need:

Prompt on object SalesDate -  based on interval values  "From" and "To".

Default values  is calculated, but able to change with prompt.

Is it possible ?