Skip to Content
author's profile photo Hajime Naya
0
Hajime Naya

Customize prompt value in Web intelligence

Posted on Jul 20, 2020 at 09:11 AM 46 Views

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...

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo M Mohammed
    M Mohammed
    Posted on Jul 20, 2020 at 04:13 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Hajime Naya
    Hajime Naya
    Posted on Jul 21, 2020 at 01:06 AM
    0

    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!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.