on 09-30-2009 10:32 PM
Hi Experts,
I have WEBI Report With Calendar Date (0CALDAY) Object on a OLAP Universe (OLAP Universe built on SAP BW BEx Query).
I need to create a prompt on Calendar Date Object with default value as Current date (systemdate). I need to create this at universe level not at BEx level (No Exceptions).
Looking forward to hear from you.
-Thanks,
Deepu
Hi,
whats the problem to use the EXIT variable here ?
Ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi BOCP-BOE,
"Current Date object in Prompt syntax" ?
You mean any Inbuilt function in Universe to build current date object. I dont see any Inbuilt functions related to current date or sysdate for OLAP Universes.
Hi Ingo,
I agree with you but we need someone who knows ABAP code to create EXIT variable. Correct me if I am wrong. In mean time i will contact BW Team.
-Thanks,
DEEPU.
Hi Ingo,
We have created SAP EXIT variable which can be used as:
Calendar day From: (Default's to Current datedate -30)
Calendar day To: (Default to Current date)
When i run WEBI Report by default i am getting data for previous 30 days,
But the problem is user cannot see the "Current date -30" and "Current date" in prompt screen and also problem for me when i use userresponse Function in WEBI as I am geting empty value.
Your help is highly appreciated.
-Thanks,
DEEPU.
Hi Deepu,
Just a couple of suggestions.
Have you set the exit variable to Mandatory and Ready for input in BW? This should force it to be displayed.
Regarding the UserResponse - here is my own notes (so I can remember :o):
Copy the name of the variable from BW Query Designer
Paste the name into =UserResponse(u201Cvariable nameu201D) in WebI
If the variable has a from and to value u2013 add either From or To to the name, e.g. u201Cvariable name fromu201D
Hth.,
Jacob
Hi Jacob,
Thanks for response, I have done everything as you said except i have set SAP Exit Variable as optional because users want it to be optional.
If i choose any other date (From and To) userresponse is working. Its showing empty for default values as even we cannot see those values even in prompt screen.
-Thanks,
DEEPU
Hi Deepu,
Ok, I thought the prompt was not showing up in WebI at all, but what you are saying is that the prompt is displayed, but without the default values (even though the exit varible works as intended) and that also results in an empty UserResponse(). Unfortunately I don't know the answer to that, but you are not the only one having the problem:
Best regards,
Jacob
Hello Deepu,
1. open the Universe Designer
2. Select the Condition/Filter/Prompt
3. Edit and change the Not_Persistent to Persistent
4. Parse it.
5. Save the Universe.
6. Export it.
Now one can see the previous value selected while user refreshing second time.
Regarding: UserResponse() , Can you post exact syntax you used...
Thank You!!
Hi BOCP-BOE,
Here the problem is not about showing "previous value selected"
Issue is:
We have SAP EXIT VARIABLE in BEx Query which acts as Prompt (user variable) with Default values.
But when its used in Business Objects
The prompt is displayed, but without the default values. I mean user cannot see the default values but when he Run the Query the data is restricted for Default values.
I hope you understand.
-Thanks,
DEEPU.
Hi Ingo,
Thanks for your response.
>
> this is because a EXIT VAriable doesn't have a DEFAULT value.
>
> Ingo
But EXIT Variable has a DEFAULT value in BEx Designer. DEFAULT Value (Current system Date) is populated when a BEx Query is Run. How come it is not properly reflected into BOBJ?. It retrieves the data for Current system Date in BOBJ too when WEBI Query is run but it does not show Current system Date in prompt screen.
I hope you understand my problem.
-Thanks,
DEEPU.
Hi Ingo,
I am bit confused here you said on Oct 5th to use an Exit Variable to resolve my problem and Now you are saying that there is no Default Value for Exit Variable.
So you mean to say that there is no way in SAP BW-BOBJ Reporting that End User can be prompted with Current Date (System Date) as a Default value in his prompt screen when he Run/Refresh the WEBI Report.
Please confirm to me so that we can pass the same message to our end users during thier training.
-Thanks,
DEEPU.
Thanks Ingo,
but do you mean using the EXIT-variable as the keydate or as the list of values on which the filter can be based?
Because I have tried with an EXIT variable that only gives the date of today, as a keydate, and it still prompts with the same calender as the other keydate variables. It does not automatically put the date of today.
What am I doing wrong?
Nadine
Hello Deep,
Did you get a answer for this issue. I am also having the same issue. I want to display sysdate in a prompt, but its not showing up automatically. Please let me know if you have the answer for this. I am struggling a lot on this one. Can you please email to balu_kv@hotmail.com if you have the answer for this.
Thanks,
Bala
EXIT variable should work in SAP side not in BO side. One need to select again.
I think you have use Current Date object in Prompt syntax, if you have any
Thank You!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is effectively not possible but it is normally planned to have this feature in the next major release.
Regards,
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not possible.
You can only define static default value in the prompts.
Regards,
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.