Using MDX to create PivotTable filters

L

lunatic

Hello!



I am using OWC Pivot Table in my program. I need to make it put on
filters by passing MDX query via CommandText. I found out that when
setting CommandText to this:



Select <something> on columns, <something> on rows from <cube_name>
where ([Country].[ Jamaica])



PivotTable sets the filter by the “Country” and marks “Jamaica”. But
when you pass the following (via Connection.Execute and then via
CommandText):



Create session member [<cube_name>].[Country].[member_name] as
‘[Country].[ Jamaica]’

Select <something> on columns, <something> on rows from <cube_name>
where ([Country].[member_name])



(which is right the same!), PivotTable creates no filters, and load the
cube data on all countries.



How to make PivotTable do the same thang using calculated members,
somebody knows???



Great thanx in advance
 

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

Top