Hello,
i am using @prompt function in the select clause, but the value in the corresponding column that appears in my report is weird. I mean, i ask the user for a month (1 to 12) and a value like 256 appears in the column. It´s not always the same number but i don´t have idea how it´s being...
Webi2002,
i managed to do that, but i had to put something in the where clause otherwise BO returned me the error "Invalid table name" (i don´t understand it).
I´m trying to make him choose a month between some specified in a certain filed table.
This is what i have in select...
RMitchell,
and there is one more other thing...
Usually when i have a prompt dimension, i select something, and that is the column that appears in the report..
What will appear in this case?
Thanks again
Fernanda
Hello rmitchell,
are you saying i should write somthing like "max(@Prompt('Escolha o mês','N','Meses\Id do mês',Mono,constrained))".
BO doesn´t accept it: ORA-00903: invalid table name...
I´ve checked all relations and they are ok..
Is there any restriction to do this?'
Thxs...
PaulSGS, i never quite understood how to use two data providers or when to use them..
How can i apply that to my case..
Do you know any place where I can get information about data providers?
What i really wanted to do was something like:
In the beginning of the report ask the user a question. I don´t want to use <field> = @promtp(..) because i will filter the result obtained from the query. After i ask the question i want to keep the result and use it to calculate some measures...
Hello!
Usually when I use the prompt function i use something like
" <field> = @prompt(...)"
But can i prompt the user a question and not equal it to anything...
Basically, what i would like to do os something like
" @prompt(....)" without the "<field>"
Thanks
Hello!
This is the problem i am trying to solve.
I´m trying to generate a report that has this behaviour.
At report time, the user must have the chance to insert a year and a month that will be the references to the values he want to consult.
In the designer, i´m thinking of do this using the...
Hello!
When i put in a dimension:
"
<< table field>> IN @Prompt('Choose month','A','<<the right dimension>>',Multi,constrained)
",
is there a way i can use the result chosen by the user in other dimension?
Suppose the user chose 'January'.
If I have several measures that depend of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.