Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Restrict users from selecting Objects when creating WEB-I reports

Hi Guys,

My universe has 6 Dimension and 2 Fact tables.

The Fact tables are not joined to each other.

Each of the fact tables are joined to all the dimension tables and seperate contexts are created for each of the fact tables.

I would like to know if we can restrict or prevent the users from selecting data from both the fact tables in a single query in a Web-I report.

Problem

Ex. customer_name, product_name, country, F1.Quantity, F1.Amount, F2.cost, F2.percent

Desired result

Ex.

Query contains

dimension objects --> customer_name, product_name, country

The user adds the following objects to the above query

Fact 1 measures --> Quantity, Amount

After adding the data from Fact-1 the user should be restricted or not allowed to select objects from class containing Fact-2 measures.

Is there a way the above can be implemented?

Thanks in advance for the quick reply

~Arun

Former Member
Not what you were looking for? View more on this topic or Ask a question