Manual prompt in BO

[Former Member]

Hi.

We are using a query of BW.

In the query we have 0FISCPER(Fiscal year / period), it is empty in the cube.

We write an Fiscal year / period when the query is executed and I have created a exit variable that fill me last day of the month of this Fiscal year / period. Object 0FISCPER(Fiscal year / period), it is empty in the cube.

Webi's report, in BO it shows filter of Fiscal year / period of my query in BW but it is empty so this list doesn´t show nothing and I cannot select nothing.

I would like to be able to write the Prompt manually in Webi, I want to write values and not selecting it of a list.

Can Somebody help me?

Thank you

[former_member207342 · Accepted solution]

drag-drop your prompt object in the 'Query Filters' pane of WebI, and from the available option select "Prompt" and then click on "?" to see properties of that prompt, make sure "Select Only from List" is not check.

This way it will allow user to enter/type value.

--Kuldeep

[Former Member · Accepted solution]

Mi filter is in BW, it isnt in Webi so if I drag-drop my prompt object in the 'Query Filters' pane of WebI I´ll have two prompt so

my problem continues.

[Former Member · Accepted solution]

Hi,

In the query panel of webi -> click on edit SQL -> replace the existing prompt wit hthis formulas as

@prompt('Prompt name','Datatype (A,N,D)','Claasname\objectname','Single/multi','Free',Persistent/Non persistent) if in BOXI R3.

Cheers,

Suresh Aluri.

[Former Member · Accepted solution]

Thanks Suresh.

Can I write in this formula a value such as 002.2009?

This is my formula:

And I can write values, but I don´t know correct value formatting. Can I add in my formula a default value?

Thanks

[Former Member · Accepted solution]

yes you can add a default value to the code as:

@Prompt('Mes','A','Ejercicio/PeríodoLovMesBase',Mono,Free,Persistent,{'Default'})

But please note that you can-not define a dynamic default value, it can only be static text.

Regards,

Rohit