Hello All,
I'm using MS OLAP Services 7.0 and I have created some Calculated Measures in a cube. I've created a VB application to create local cube from the MS OLAP Server and I'm having problem when I select the Calculated Measure for populating in the Local Cube. All other Dimensions and normal Measures works fine. Is there any special syntax to select a Calculated Measure using select statement which one uses to populate Local Cubes.
One more thing I'm able to select the Calculated Measure from the MDX Sample Application that comes with MS SQL7.0 using the syntax
{[Measures].[Calculated Measure1]} on columns
whereas in the select statement of my VB app if I give
[Cube Name].[Measures: Calculated Measure1]
I get an error message saying
"Error while processing the partition: 'Column name 'Calculated Measure1' is invalid. Only level or measure names can be specified.
Any Ideas/Suggestions!
Thanks
Sridharan
I'm using MS OLAP Services 7.0 and I have created some Calculated Measures in a cube. I've created a VB application to create local cube from the MS OLAP Server and I'm having problem when I select the Calculated Measure for populating in the Local Cube. All other Dimensions and normal Measures works fine. Is there any special syntax to select a Calculated Measure using select statement which one uses to populate Local Cubes.
One more thing I'm able to select the Calculated Measure from the MDX Sample Application that comes with MS SQL7.0 using the syntax
{[Measures].[Calculated Measure1]} on columns
whereas in the select statement of my VB app if I give
[Cube Name].[Measures: Calculated Measure1]
I get an error message saying
"Error while processing the partition: 'Column name 'Calculated Measure1' is invalid. Only level or measure names can be specified.
Any Ideas/Suggestions!
Thanks
Sridharan