May 22, 2009 at 1:42 am
Hi,
I want to calculate ecart between different years, trimestres, months..
This is why I calculate "(number of clients)-1" which is my measure in one periode parallel.But I can't put up that value. SSAS navigater put up "#value" when I select that new number calculated. I couldn't find where I did a mistake:
My new member calculated:
([Measures].[v Cube Synthese Nombre],
parallelPeriod
(
[Tb Periode].[date analyse].[Annee] ,
1,
[Tb Periode].[date analyse].[Tri Annee] .currentMember
)
)
And when I put the mouse icon at this "#value" It is put up that information:
"the function CURRENTMEMBER waits a expression of hierarchie for argument.."
Hve u got ideas pleasee???
May 25, 2009 at 6:16 am
Alsanhanc,
the error is due to the syntax you have in the second portion of the mdx. [Tri Annee] must be removed for the calculation to work.
May 25, 2009 at 8:29 am
hi,
tnnx for your response but I tried to code like that, too.
The problem is:
my dimension table is:
date_ref year trimestre tri_year
2007-12-31 2007 4 42007
2008-09-30 2008 3 32008
2008-12-31 2008 4 42008
2009-04-30 2009 2 22009
I have a hierarcy whom name is "date analyse" and it is constructed by:
year
trimestre
date_ref
when I study on cube navigater; when I select periode dimension without mesure, it puts up well all dimensions.
But when I want to put up also
My new member calculated for all the quarter of 2008 and 2009:
([Measures].[v Cube Synthese Nombre],
parallelPeriod
(
[Tb Periode].[date analyse].[Annee] ,
1,
[Tb Periode].[date analyse].currentMember
)
)
But it puts up only
2008 3.quarter
2009 2.quarter
but not 2008 4.quarter:( I understand why it doesn't put up the measures oif 2007 because I have no parellel periode for 2007(I have no measure of 2006 dans la base de données)
Do u have any idea why it doesn't put up the measures of 2008 4.quarter??I have already 2007 4.quarter in my database.
May 25, 2009 at 9:32 am
If you are getting results, but not the right results... it is probably an issue with the hierarchy attributes in the dimension.
When you view your hierarchy in BIDS are there any warnings associated in the dimension?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply