V
Vidas M
Hi,
We have application that uses Office Web Components to access Microsoft
Analysis Services 2000 and shows reports in Pivot Table Services format.
User has an option to choose from a list of all available dimensions. What
we would like to do is to limit in the front end list of available
dimensions. I know that I could do this by creating Virtual cube in analysis
services and limit available dimensions there. But for specific reason we
would like to do this in the front end.
What I am looking for is most likely some sort of script (VBA, JScript etc)
that would let me hide some dimensions. Anyone done that and can point me to
the right direction?
Thanks in advance,
Vidas M.
We have application that uses Office Web Components to access Microsoft
Analysis Services 2000 and shows reports in Pivot Table Services format.
User has an option to choose from a list of all available dimensions. What
we would like to do is to limit in the front end list of available
dimensions. I know that I could do this by creating Virtual cube in analysis
services and limit available dimensions there. But for specific reason we
would like to do this in the front end.
What I am looking for is most likely some sort of script (VBA, JScript etc)
that would let me hide some dimensions. Anyone done that and can point me to
the right direction?
Thanks in advance,
Vidas M.