cancel
Showing results for 
Search instead for 
Did you mean: 

Customize prompt value in Web intelligence

hajime78
Explorer
0 Kudos

Thanks for helping Exports...

I couldn't find correctly answer as my question in the site. therefore I'd like to ask here.could you help me?

I guess need to setting Univers in information design tools but no knowledge now....

Request

Once choose Calendar "From" then Calendar "To" show between Calendar "From" and "From" + 1 year.

Condition

adding Calendar "From" and "To" in prompt windows (prompt setting type is list of value)

using 1 master table (ex. 202001,202002,202003....)

Thanks for reading...

Accepted Solutions (1)

Accepted Solutions (1)

mhmohammed
Active Contributor
0 Kudos

Hi Hajime,

Can you please explain clearly with an example and some screenshots?

Do you need 1 or 2 prompts in the filter you will be creating in the Universe?

Do you have an object already that can give you the list of values as 201901, 201902,..., 202001, 202002, 202003... and so on?

1. If you've 1 prompt only (say From prompt only), what months data should be pulled in the report if you select 201906?
2. If you've 2 prompts (say From and To), what months data should be pulled in the report if you select From as 201906 and To as 202006? Why I ask this is because in your question you specified "Once choose Calendar "From" then Calendar "To" show between Calendar "From" and "From" + 1 year" and that bold part is confusing.

Checkout the below blogs, they can give you an idea of the syntax you'll need to use, depending on the backend database.

https://blogs.sap.com/2018/11/18/web-intelligence-dynamic-date-filter-with-relative-values-prompt/

https://blogs.sap.com/2015/11/26/custom-prompt-at-universe-level/

Thanks,
Mahboob Mohammed

Answers (1)

Answers (1)

hajime78
Explorer
0 Kudos

Dear Mahboob san,

thanks pick it up!! (last time also) sorry no photo... i will try with photo when i send question request.

yes, you correct. and choose option 2.

and Select From should be one.(ex. 201901, bad. 201901,201902...202001 )

finally i found how to create in the universe.

1.create parameter linked with "Calendar From" . name is "DATE_From" for explain

2.create list of values under custom SQL.

"Select yyyymm from Calendar_Table_Name

where yyyymm between @prompt(DATE_From) and @prompt(DATE_From)+1year"

3.first select Calendar From in prompt window

4.can see Calendar From to Calendar From + 1 year in Calendar To.

thanks a lot as always!!