Fully restricted Dimension still visible in PT FieldList

[Mohammed Rabbani]

Hi,

I have an owc10 pivottable componennt in an asp page connecting to an
analysis cube (sql 2000 analysis server).

A role is defined in the cube which fully restricts one dimension in the
cube. The role is being passed in the connection string from the pivottable
in the asp page.

The dimension which is fully restricted for this role is still visible in
the pivottable FieldList, but when dragged into the pivottable column/row
areas, it gives an error. The rest of the dimensions in the cube are working
o.k.

My question is, Is it possible to completely remove this dimension from the
pivottable fieldlist itself. Since, it is fully restricted, we don't want
some of our users to see that dimension or even know that it exists in the
cube.

Any help in this regard will be highly appreciated.

Thanks,
Rabbani

 

[Alvin Bruney [MVP]]

what is the error you receive?

 

[Mohammed Rabbani]

Hello,

The error is "The query could not be processed: The data provider didn't
supply any further error information.".

However, I am looking for ways to completely remove this dimension from the
fieldlist.

So far what I could understand is that, the FieldList is being populated
from the metadata of the cube and the restrictions based on the role are not
being checked when reading the metadata of the cube to populate the fieldlist.

Thanks,
Rabbani

what is the error you receive?

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,

I have an owc10 pivottable componennt in an asp page connecting to an
analysis cube (sql 2000 analysis server).

A role is defined in the cube which fully restricts one dimension in the
cube. The role is being passed in the connection string from the
pivottable
in the asp page.

The dimension which is fully restricted for this role is still visible in
the pivottable FieldList, but when dragged into the pivottable column/row
areas, it gives an error. The rest of the dimensions in the cube are
working
o.k.

My question is, Is it possible to completely remove this dimension from
the
pivottable fieldlist itself. Since, it is fully restricted, we don't want
some of our users to see that dimension or even know that it exists in the
cube.

Any help in this regard will be highly appreciated.

Thanks,
Rabbani