Filter Cube / Pivottable

[AykutArslan]

Hi, how can I solve the following problem (for the school).

# Facttable
yield

# Dimension 1 (Area) with 4 Levels
Country, Region, Farmer, Field

# Dimension 2 (Time) with 1 Level
Year

# What do I have right now?
I have a cube. I can show "ALL" data from the cube.
(Web Admin is able to see all data from all countries.)

I have created a pivottable via Excel 2003,
saved the file as HTML, copied on server.
Web Admin can access to this file and see all data.

# Problem
Country Admin is not allowed to see data from all countries.
Primary he can see only data from his own country.
But Web Admin is able to grant Country Admin
to see also data from a specific other country.
(There is already a RDB table, that contains the information
about which country is able to see data from which another country.)

# What is my goal ?
I want to filter data by country.
I.e. if Country Admin from Switzerland wants to access
the pivottable (the html file), he should only see data from Switzerland
and all data from other countried which he is able to see.

Andy idea how to solve this problem?

I work with :
Win2K, SQL Server 2000, Analysis Server,
PHP & Smarty, Apache

 

[AykutArslan]

Following is the HTML file.
Here, you only see one country,
because right now, only one country is in the system.
But its possible for many countries.

Back to my problem.
Web Admin would see all countries in the system.
I would like to pass parameter to this file,
so that one can see only specific countries.

 

[MDXer]

there are 2 ways to handle this both requiring the use of NT Authentication.

1) Utilize cell level security setting up roles that are mapped to your users and allow or disallow the data they can or can't see.

2) Use a security cube. This method I have only read about but is supposed to be more versitile than the other method.

the first method can have a performance hit depending on the size of your dimensions in relation to the number of custom user roles and the size of the machine hosting the cubes.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[AykutArslan]

Its an online application.
User logs in via php.