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
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