Security concerns about OWC11 accessing an Analysis Services cube

D

Diaa

Hello,

If I use OWC11 to access an Analysis Services OLAP Cube, and I want to
filter the data retreived in a report according to the division of the user,
can i hardcode the division in the MDX query?
Can I write my own MDX queries with OWC11?


Thank you,

Diaa
 
J

Johnyc

I'm not sure how you are hosting OWC11 and I'm also not sure about using MDX.
But if you can use VBScript or VB, the IncludedMembers Property with an
example in the OWCVBA11.CHM help file included with OWC11 may help.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top Filter diffrence in excel and owc 3
Visual Totals functionality when not using the MSOLAP provider 0
Visual Totals functionality when not using the MSOLAP provider 6
OWC11 - Accessing MS Analysis Server via HTTP 1
OWC 11 Pivot Table 3
MDX Statement to an SQL Server Analysis Services with ADO 0
Problem with creating Data Analysis View 3
Pivot Table Log File 0

Top