Skip to Content

Universe fiscal period Object

Hi,

I have isolated derived table class folders, each folders have fiscal year/period prompt filters built at the universe level....

At webi report this filter is mandatory and should show one fiscal year/period prompt filter by keeping the same prompt text. Could you please assist is it good to go with these settings at the universe and the report level.

Thanks,

Dinya

Capture.JPG (34.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 21, 2015 at 08:53 PM

    Hi,

    First you needs to understand how these options will work.

    Use Filter Mandatory in query (Apply on Universe) :If you select this option then no needs to add filter condition manually (drag the filter in filter panel).Automatically users will get the prompt option to enter the value in webi query.

    Use Filter Mandatory in query (Apply on Class):If you select this option then when ever user drag the object from this particular class,users will get the prompt to enter the values in webi query.


    In your case where independent classes for independent derived table,this option will not work.Like if you will  create the filter on delhi derived table objects and select the option "Use Filter Mandatory in query (Apply on Universe)" then If you create the webi report on top of Mumbai class,you will get the prompt because you have selected the  filter as "Use Filter Mandatory in query (Apply on Universe)" .


    Better option is do not select "Use Filter Mandatory in query" option for any filter.When these filter required manually/drag these filters in webi filter panel.


    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Amit,

      As iam creating an independent report tabs for each data provider of derived tables, have an thought process will it do union by default at webi having prompt text as same for both dataproviders delhi and mumbai or

      Other to  create Custom LOV's at universe level for let say Fiscal Year /Period from delhi class. webi prompt select the option "Prompt with List of values" option for delhi prompt condition. With this you will get the prompt once and custom LOV's from Delhi Object.

      Thanks,

      Dinya.

  • avatar image
    Former Member
    Oct 21, 2015 at 08:40 PM

    Hi,

    You can create @prompt for same.

    This will help you to create prompt with same text in every report.

    What you have to do is simply drag the object having @prompt definition in every report you are creating.

    I hope this will help.:

    For more detail on @prompt refer below link:

    http://business-objects-xi.blogspot.co.uk/2009/06/prompt.html

    Thanks,

    Swapnil

    Add comment
    10|10000 characters needed characters exceeded