|
I have condition like below in universe which works fine
Object. City in @prompt('Enter City','A',,Multi,Free,Not_Persistent,{' '},
but below gives me error
Object. City in case when @prompt('Enter City','A',,Multi,Free,Not_Persistent,{' '} = ' ' then...
Started by toblerone65 on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at forumtopics):
The problem is with only with multi prompt case statement does not gel well I can think of to get your desired....
Hi,
Try the other way around: Code: Object.City IN CASE WHEN ' ' IN @prompt('Enter City','A',,Multi incorrect syntax near CASE.
|
|
Hi all,
I am trying to create an optional prompt on the universe side. I have been reading through some material and below is the prompt I have created but when I try to parse I get an error about 'parsing default parameter (7th parameter)'.
I have tried...
Started by Jenm1 on
, 11 posts
by 9 people.
Answer Snippets (Read the full thread at forumtopics):
You'll haveA) I thought that as of XI 3.1 SP3 optional prompts are NOT supported on the universe side
B to understand this as....
See my post on creating an optional prompt in the universe (with screen shots).
It in the future.
|
|
Hi,
I am currently working on designing a WEBI report with db2 as my database. I have a requirement where when a user selects a particular date in the webI query filter, the report should return that day's data and the previous day's data. Here the current...
Started by BOB newbie on
, 7 posts
by 3 people.
Answer Snippets (Read the full thread at forumtopics):
Prompt, use twice in a pre-defined condition
Valuation_date = @Prompt(--- your prompt here)
or
Valuation_date = @Prompt(--- your prompt here)-1
Note that the two @Prompt statements must be exactly for the previous....
|
Ask your Facebook Friends
|
Hello,
I have the following issues with WebI report selection input paramaters (prompts) that use BW BEx Query variables. Could anyone please assist?
Issue 1:
The WebI report has one mandatory and two optional input paramaters (all paramaters from BW ...
Started by BI001AS on
, 11 posts
by 5 people.
Answer Snippets (Read the full thread at sap):
Webi usually take the prompt order alphabatically....
The order of prompt.
Order of the prompts we need to visit the universe and there we need to change the prompt definitionHi,
I can tell you the answer of your second question.
|
|
I am trying to use the Rebean SDK to set the order of prompts in a XI3.1 SP3 Webi document. This document does contain universe prompts, i.e. a table has a self join with @Prompt() . Looking through the Javadocs, I see a PromptOrder class, but it only...
Started by Ryan Gordon on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at sap):
Open the report in edit mode and click on editquery buuton, but I was already aware... .
In the @prompt declaration at the universe level defined at the report instead of universe.
Then u can follow the below prompt declaration .
|
|
We think we've isolated the issue and corrected it. We'd like to be sure though.
If anyone has had the issue related to updating their java because of a prompt on this site after 10:00am MT, let us know by posting here. Also post any screen caps, firebug...
Started by Alastor on
, 15 posts
by 6 people.
Answer Snippets (Read the full thread at denverbroncos):
Errr I just closed the window the issue related to updating their ... .
Ill screen cap it if youd like hold on.
Have yet to receive the Java prompt and I should have been prompted by now (Had it several times that prompt this second...
|
|
How to list universe objects from a webi report using the Business Objects SDK for XIR2?
Is there is an automated way to do it without the sdk?
With the SDK I've been able iterate through webi report and universe collections but do not see a native way...
Started by jms on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The following query will return the SI_ID values for each report associated with a universe:
SELECT * FROM CI_APPOBJECTS WHERE SI_KIND='Universe'
Using Query Builder, the following query will return,SI_UNIVERSE,SI_HAS_PROMPTS....
|
|
Hi All,
We have create prompts in information design tool and included it in query browser's filter panel.
We want to connect the prompts to the dashboard design tool , i need to use the prompt filter which is created in universe level .
Through QAAWS...
Started by Latheesh PV on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at sap):
Developed at universe (UNX) level using @prompt function, those prompts are appearing while running of X.I 3 this facility was there that if whatever we are giving as prompt from universe level(with Prompt option....
|
|
I am new obviously and this is my first use of prompts in a universe.
I would like to prompt for SSN and then use the value for the following select
select a, g,c from y_Table where
y_Table.primary_ssn = Value of the prompt
or
y_Table.secondary_ssn = ...
Started by wizard2012 on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at forumtopics):
To two different prompts?
TRY:
select a, g, c
from y_Table
where
y_Table.primary_ssn = @prompt('prompt Message','A','classname\object1',Multi,Free)
or
y_Table.secondary_ssn = @prompt('prompt Message','A','classname\....
|
|
How to prompt the current date in the report?
Started by jayababuhrd on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at forumtopics):
Hi ,in report level i need the promptCan you be more clear?
If it is just a prompt on current date then create a prompt filter to prompt the current date ....
In the universe using the Sysdate function to pull the currentdate.
|
