I have used the ParallelPeriod function in past versions of Cognos Report Studio, so I am unsure why I am having such a difficult time??
So I have a basic powercube created in Transformer 10.1, and it has a Time dimension with the following levels
Here is the code I am using within a Data Item:
parallelPeriod ([Crown MA National Cube 10_1].[Time Dim].[Calendar Time Periods].[Calendar Year], 1, [201301])When I run this, I get nothing!
I have tried a variety of versions with the ParallelPeriod, still get nothing returned.
Any ideas would be great!
Thanks!
So..I am still trying to figure out what could be wrong with my Time dimension that would not allow me to use the ParallelPeriod MDX function. So I went and tried the function in a GoSales Cube, and it worked there.
One thing I noticed was the member used in the calculation (parallelPeriod ([Crown MA National Cube 10_1].[Time Dim].[Calendar Time Periods].[Calendar Year], 1, [201301]))...the [201301] has a MUN like this --> [Crown MA National Cube 10_1].[Time Dim].[Calendar Time Periods].[Calendar Month]->:[PC].[@MEMBER].[20130101-20130131]
This last part is what bothers me...in other examples the MUN for a Month member comes out to one value...
Could this be the culprit? And if so, what exactly could I have done in Transformer to get this to come out this way?
Any assistance would be appreciated..thanks!