pivottable subcube

[JohannaK0101]

I have a single analysis services 2005 cube with 25 different
regions.

I'm using the OWC pivottable component and I'd like to restrict users
to the regions that they administer. I can do a simple "CREATE
SUBCUBE" with the restricted regions in SSMS, but I don't know how to
filter the cube view for OWC. Can anyone provide a pointer? I've spent
all day on this!

I also thought about trying a hidden filter of some kind, but couldn't
find a way to do that. Alternatively, I thought I might be able to
create a "perspective" on the server... but it seems like those are
only for Measures and this is for specific values in a dimension
("Region" is a dimension)

 

[Alvin Bruney [ASP.NET MVP]]

There isn't anyway to do this from the pivot table component itself. You
will need to perform the restrictions from the MDX query level.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[JohannaK0101]

There isn't anyway to do this from the pivot table component itself. You
will need to perform the restrictions from the MDX query level.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively onwww.lulu.com/owc$19.99
-------------------------------------------------------

I have a single analysis services 2005 cube with 25 different
regions.

I'm using the OWC pivottable component and I'd like to restrict users
to the regions that they administer. I can do a simple "CREATE
SUBCUBE" with the restricted regions in SSMS, but I don't know how to
filter the cube view for OWC. Can anyone provide a pointer? I've spent
all day on this!

I also thought about trying a hidden filter of some kind, but couldn't
find a way to do that. Alternatively, I thought I might be able to
create a "perspective" on the server... but it seems like those are
only for Measures and this is for specific values in a dimension
("Region" is a dimension)- Hide quoted text -

- Show quoted text -

Hi Alvin,

Thanks for the reply! (by the way, I have your book... but not the
newer version yet). Anyway, I can do the query as MDX, but do you know
of any way to present the different users with the subcube results of
the MDX? I tried using the "CREATE SUBCUBE" restriction as the
CommandText, but that didn't work.

If I write CREATE SUBCUBE statements elsewhere, the SUBCUBE doesn't
persist, does it?

I don't know any way to create a bunch of subcubes and have them stick
around outside a session. The only solution I've thought of is
separately deploying 25 different cubes with different "WHERE" clauses
in the data source view... not very appealing. Am I approaching the
whole problem incorrectly? It seems like it would be a common
scenario.

J

 

[Alvin Bruney [ASP.NET MVP]]

You should approach this the way web applications targetting a db operate.
The request from the client will identify the user, say either through
windows authentication or some other way of identifying the user. You'll
need to tie into one of the click events and add the where clause to the
query so that what comes back is specific to that user.. "queryclases" from
cube where user = 'webuser' roughly

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

There isn't anyway to do this from the pivot table component itself. You
will need to perform the restrictions from the MDX query level.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively onwww.lulu.com/owc$19.99
-------------------------------------------------------

I have a single analysis services 2005 cube with 25 different
regions.

I'm using the OWC pivottable component and I'd like to restrict users
to the regions that they administer. I can do a simple "CREATE
SUBCUBE" with the restricted regions in SSMS, but I don't know how to
filter the cube view for OWC. Can anyone provide a pointer? I've spent
all day on this!

I also thought about trying a hidden filter of some kind, but couldn't
find a way to do that. Alternatively, I thought I might be able to
create a "perspective" on the server... but it seems like those are
only for Measures and this is for specific values in a dimension
("Region" is a dimension)- Hide quoted text -

- Show quoted text -

Hi Alvin,

Thanks for the reply! (by the way, I have your book... but not the
newer version yet). Anyway, I can do the query as MDX, but do you know
of any way to present the different users with the subcube results of
the MDX? I tried using the "CREATE SUBCUBE" restriction as the
CommandText, but that didn't work.

If I write CREATE SUBCUBE statements elsewhere, the SUBCUBE doesn't
persist, does it?

I don't know any way to create a bunch of subcubes and have them stick
around outside a session. The only solution I've thought of is
separately deploying 25 different cubes with different "WHERE" clauses
in the data source view... not very appealing. Am I approaching the
whole problem incorrectly? It seems like it would be a common
scenario.

J

 

[Joe]

you might also want to look into dimension level security on SSAS 2005. if
you use windows authenication, you can create different roles with
permissions to only the regions you want for each role.

that way there is no filtering on the front and they will only be able to
see the regions that they have security permissions for.

hope this helps.

You should approach this the way web applications targetting a db operate.
The request from the client will identify the user, say either through
windows authentication or some other way of identifying the user. You'll
need to tie into one of the click events and add the where clause to the
query so that what comes back is specific to that user.. "queryclases" from
cube where user = 'webuser' roughly

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

There isn't anyway to do this from the pivot table component itself. You
will need to perform the restrictions from the MDX query level.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively onwww.lulu.com/owc$19.99
-------------------------------------------------------





I have a single analysis services 2005 cube with 25 different
regions.

I'm using the OWC pivottable component and I'd like to restrict users
to the regions that they administer. I can do a simple "CREATE
SUBCUBE" with the restricted regions in SSMS, but I don't know how to
filter the cube view for OWC. Can anyone provide a pointer? I've spent
all day on this!

I also thought about trying a hidden filter of some kind, but couldn't
find a way to do that. Alternatively, I thought I might be able to
create a "perspective" on the server... but it seems like those are
only for Measures and this is for specific values in a dimension
("Region" is a dimension)- Hide quoted text -

- Show quoted text -

Hi Alvin,

Thanks for the reply! (by the way, I have your book... but not the
newer version yet). Anyway, I can do the query as MDX, but do you know
of any way to present the different users with the subcube results of
the MDX? I tried using the "CREATE SUBCUBE" restriction as the
CommandText, but that didn't work.

If I write CREATE SUBCUBE statements elsewhere, the SUBCUBE doesn't
persist, does it?

I don't know any way to create a bunch of subcubes and have them stick
around outside a session. The only solution I've thought of is
separately deploying 25 different cubes with different "WHERE" clauses
in the data source view... not very appealing. Am I approaching the
whole problem incorrectly? It seems like it would be a common
scenario.

J

 

[Alvin Bruney [ASP.NET MVP]]

I think that's a better solution than mine.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

you might also want to look into dimension level security on SSAS 2005.
if
you use windows authenication, you can create different roles with
permissions to only the regions you want for each role.

that way there is no filtering on the front and they will only be able to
see the regions that they have security permissions for.

hope this helps.

You should approach this the way web applications targetting a db
operate.
The request from the client will identify the user, say either through
windows authentication or some other way of identifying the user. You'll
need to tie into one of the click events and add the where clause to the
query so that what comes back is specific to that user.. "queryclases"
from
cube where user = 'webuser' roughly

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

On Apr 1, 6:35 pm, "Alvin Bruney [ASP.NET MVP]" <www.lulu.com/owc>
wrote:
There isn't anyway to do this from the pivot table component itself.
You
will need to perform the restrictions from the MDX query level.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively onwww.lulu.com/owc$19.99
-------------------------------------------------------





I have a single analysis services 2005 cube with 25 different
regions.

I'm using the OWC pivottable component and I'd like to restrict
users
to the regions that they administer. I can do a simple "CREATE
SUBCUBE" with the restricted regions in SSMS, but I don't know how
to
filter the cube view for OWC. Can anyone provide a pointer? I've
spent
all day on this!

I also thought about trying a hidden filter of some kind, but
couldn't
find a way to do that. Alternatively, I thought I might be able to
create a "perspective" on the server... but it seems like those are
only for Measures and this is for specific values in a dimension
("Region" is a dimension)- Hide quoted text -

- Show quoted text -


Hi Alvin,

Thanks for the reply! (by the way, I have your book... but not the
newer version yet). Anyway, I can do the query as MDX, but do you know
of any way to present the different users with the subcube results of
the MDX? I tried using the "CREATE SUBCUBE" restriction as the
CommandText, but that didn't work.

If I write CREATE SUBCUBE statements elsewhere, the SUBCUBE doesn't
persist, does it?

I don't know any way to create a bunch of subcubes and have them stick
around outside a session. The only solution I've thought of is
separately deploying 25 different cubes with different "WHERE" clauses
in the data source view... not very appealing. Am I approaching the
whole problem incorrectly? It seems like it would be a common
scenario.

J