January 12, 2011 at 6:19 am
i have two measure groups(m1,m2) and one dimension(m3) in my (sqlserver2008enterprise)SSAS cube
select [m3].[attribute1].members on rows,
[Measures].members on columns
from [cube]
it displays whole data from both measures
if i write query like
select [m3].[attribute1].members on rows,
[Measures].[m1].members on columns
from [cube]
it diplays
Query (2, 1) The member '[m1]' was not found in the cube when the string, [Measures].[m1], was parsed.
Execution complete
i wanted to retrive entier data from 1 measure group(m1)
plz hlp....
[font="Verdana"]SRIHARI(:~[/font]
January 18, 2011 at 4:15 am
SELECT [Measures].[M1] on 0,
[Dimension].[DimensionName] on 1
FROM CUBE
Raunak J
January 18, 2011 at 4:44 am
thanks for replay
it displays the following message
Executing the query ...
Query (1, 8) The member '[Batting]' was not found in the cube when the string, [Measures].[Batting], was parsed.
Execution complete
[font="Verdana"]SRIHARI(:~[/font]
January 18, 2011 at 4:50 am
OK. This is the case of MDX member missing
What version of Analysis service instance are you using
Raunak J
January 18, 2011 at 4:52 am
January 18, 2011 at 5:37 am
i am using MS analysis service(10.0.1600.22)
sqlserver 2008 Enterprise edition(10.0.1600.22)
[font="Verdana"]SRIHARI(:~[/font]
January 20, 2011 at 10:04 pm
You may set the MDXMemberMissing property to ignore in SSAS
Raunak J
January 20, 2011 at 10:43 pm
Why not use the MeasureGroupMeasures() function? Official doc here
Using your example....
select [m3].[attribute1].members on rows,
MeasureGroupMeasures('m1') on columns
from [cube]
Steve.
January 20, 2011 at 10:54 pm
stevefromOZ (1/20/2011)
Why not use the MeasureGroupMeasures() function? Official doc hereUsing your example....
select [m3].[attribute1].members on rows,
MeasureGroupMeasures('m1') on columns
from [cube]
This is the case of member missing. MGM() will not handle this explicitly.
Raunak J
January 20, 2011 at 11:04 pm
"You may set the MDXMemberMissing property to ignore in SSAS "
where can i find this property in ssas
[font="Verdana"]SRIHARI(:~[/font]
January 20, 2011 at 11:07 pm
SSAS-->CubeBrowser-->Select a Dimension-->Properties
Raunak J
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply