Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivottable - disable dimension

Status
Not open for further replies.

AykutArslan

Programmer
May 5, 2004
5
DE
I have a pivot table (*.xls), which has beyond others a dimension named "area".
It has different countries as the following pic shows.

olap_q0.gif


Each country has analysis values. (The values are from MS Analysis Services.)

Application Rules:
A Web Admin is allowed to see data from all countries.
A Country Admin e.g. USA is allowed to see only data from his country.

Within the Excel file, where the pivot table is,
I can decide which country I would like to see.

olap_q1.gif


My goal is to present the content on Internet. Therefore I save the Excel file as html file,
(with the interactive option for pivot table).

Next pic shows, how it looks on Internet Explorer.

olap_q2.gif



My problem is the next pic.

olap_q3.gif


As you see, the US Coutry Admin has the posibility to see
also data from other countries,
even I have selected the country USA before I saved as html file.
He only needs to check the country he wants to see,
which is against the rules.

Question:
How Can I disbale this area, so that USA Country Admin
(same for other Country Admins) can only see data
from his country.
(He should not get the chance to select another country.)

Aykut
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top