Hi friends,
I have this doubt that is really getting on my nerves now...dont know what I am missing...All kinds of help/advice/suggestions would be extremely appreciated.
I have a value prompt for Year. My package is of DMR nature.
My intention is to fetch the Year value entered in prompt, and use that to create 4 members that will actually be the quarters for that year.
MemberUniqueName for Year : [Presentation Layer].[Source Received Date].[Source Received Date].[Year]->[all].[2013]
I am successfully able to create the Quarter members such as : #'[Presentation Layer].[Source Received Date].[Source Received Date].[Quarter]->[all].[substring ( ?Year? , 83 , 4 ) ].[1]'#
I save this in a data item named Qtr1.
Now I want to use Tuple function to create intersection values for a crosstab :
tuple ( [Complaint Volume] , [Qtr1] , currentMember ( [Presentation Layer].[Requestor Level].[Requestor Level] ) )
This is not giving any output. But when I directly use a Quarter member from source like :
tuple ( [Case Count] , [2013 - Quarter1] , currentMember ( [Presentation Layer].[Requestor Level].[Requestor Level] ) )
it gives the required output.
Please tell me where I am going wrong!
[substring ( ?Year? , 83 , 4 ) ???? thats a pretty long string year parameter
Quote from: DhimanBiswas on 13 Mar 2014 12:02:37 AM
Hi friends,
I have this doubt that is really getting on my nerves now...dont know what I am missing...All kinds of help/advice/suggestions would be extremely appreciated.
I have a value prompt for Year. My package is of DMR nature.
My intention is to fetch the Year value entered in prompt, and use that to create 4 members that will actually be the quarters for that year.
MemberUniqueName for Year : [Presentation Layer].[Source Received Date].[Source Received Date].[Year]->[all].[2013]
I am successfully able to create the Quarter members such as : #'[Presentation Layer].[Source Received Date].[Source Received Date].[Quarter]->[all].[substring ( ?Year? , 83 , 4 ) ].[1]'#
I save this in a data item named Qtr1.
Now I want to use Tuple function to create intersection values for a crosstab :
tuple ( [Complaint Volume] , [Qtr1] , currentMember ( [Presentation Layer].[Requestor Level].[Requestor Level] ) )
This is not giving any output. But when I directly use a Quarter member from source like :
tuple ( [Case Count] , [2013 - Quarter1] , currentMember ( [Presentation Layer].[Requestor Level].[Requestor Level] ) )
it gives the required output.
Please tell me where I am going wrong!
Hi,
Why do this? Why not simply use the children() function to locate the four quarters in the hierarchy that comprise the children of the year member? You seem to be creating a really complex solution to s simple problem? Or am I missing something?
eg children(item([your Year level] -> ?Your year parameter?,0))
Cheers!
MF.
Sorry for late reply.
I have a detail filter here; so the quarter value/s selected in prompt will be of string nature!