If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

ParallelPeriod Function Not Working With PowerCube in 10.1??

Started by torre2011, 02 Jul 2013 03:23:32 PM

Previous topic - Next topic

torre2011

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

  • Years
  • Quarter
  • Month

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!

torre2011

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!