Mandatory (& Optional due to LOVs) Prompt on the UNX

[mhmohammed]

All,

I've to apply a Mandatory Prompt on the object Client Type in the Universe.

Client Type = Professional/Consumer.

The title of the post says Optional due to LOVs because I want to bring in Professional or All (Professional & Consumer) clients in the report. So I modified the LOV to get All & Professional in the LOV and I created the Filter in the Universe as well with the logic Client Type = @Prompt() or All in @Prompt() and made it Mandatory on Folder in the Universe. What do I need to do so I can include this filter in all the Contexts in which Client Info is included?

Because, when I ran a query by just pulling in Client info, the filter works fine, but when I add some Sales info to the query, I get no data in the report.

Thanks,

Mahboob Mohammed

[former_member4998]

Hi...

Due to the potential complexity of the @Prompt definition, especially when typing in a list of values, it is recommended to use the @Prompt editor.

And copy the SQL from "View Script" option and run the DB and check whether getting correct data or not. If you are not getting correct data plz check Sales info and Client type Prompt have compatibility or not.

[mhmohammed]

Thanks Sreenivas

The no data error is gone as I replied to Mishra, but on question still remains, the one that I wrote in Red in the first post.

Thanks,

Mahboob Mohammed

[Former Member]

I am not sure if I understood this question fully.

But looking at what you are trying to achieve I will suggest to create a folder for the client objects and create this filter in the same folder where the client object are setup and then in the filter properties just  select check boxes "use filter as mandatory on query" and then select the radio button "Apply on filter"

[mhmohammed]

Thanks Mishra.

FYI: The no data error is resolved, I was filtering on a very small range of dates, so the query wasn't retrieving any data.

I already made this a Mandatory filter in the Client Info folder, but I want to include this filter in 3 out of 6 Contexts (Business Activities) that I have in the Universe, doesnt matter if I Add/Not anything from Client Info in the query.

Available Contexts: C1, C2, C3, C4, C5, C6

Suppose, we can pull in Client Info data for C1, C2, C3 only.

If I just make create this filter in the Client Info folder......What if I run a report to bring data from one of the 3 contexts and dont pull in any objects from Client Info folder?  This filter wont be applied as I didnt pull anything from the Client Info folder.

Ex Query: Object 1, Object 2, Object 3 (from C1/C2/C3) and Object 1, Object 2 (from Client Info folder)

Result: Filter will be included

Ex: Query: Object 1, Object 2, Object 3 (from C1/C2/C3) and no objects from Client Info folder

Result: Filter will not be included as I didn't add anything from Client Info folder

Seems, I'll have to duplicate this folder in the folders I have in the Universe for each of the Contexts...what say you?

Thanks,

Mahboob Mohammed