Issue on Filtering when Population measure is used.

[cognos05]

HI ALL,

I am using Dimensional Reporting and facing an issue and I am trying to fix it.

I have the measure as Sales , I also need to show the population for the accounts in one column which is a second Measure along with the products.

CrossTab looks like below,

   Sales                       Population   Product1  Product2
Distributor 1               1500             2545        450
Distributor 2               1200              650         650
Distributor 3               2750              725        432

In the cube ,the population is loaded only once and it residesalways in say jul/2015.

But sales is for all months.

Now when we use a Months as a prompt, the population value goes off to empty when other months are chosen which is ideally correct, but I want this population value to be fixed.

I have the expression for population as Tuple([2015/July],[Population])
And my slicer for the months is
#promptmany('prmMonth','mun','[DistributorSalesCube].[Time Period].[Time Period].[Months]->:[PC].[@MEMBER].[' + timestampMask(_first_of_month($current_timestamp),'yyyymmdd')+ '-' + timestampMask(_last_of_month($current_timestamp),'yyyymmdd') + ']','set(','',')')#

Which is a macro for allowing user to choose multiple prompts.


My slicer overrides the population value. I dont want this to happen. I am not sure how to achieve this.Any help is appreciated.

Now I am able to report only on YTD but not on months, the population value becomes empty for all the months except july 2015

Thanks,

[MFGF]

HI ALL,

I am using Dimensional Reporting and facing an issue and I am trying to fix it.

I have the measure as Sales , I also need to show the population for the accounts in one column which is a second Measure along with the products.

CrossTab looks like below,

   Sales                       Population   Product1  Product2
Distributor 1               1500             2545        450
Distributor 2               1200              650         650
Distributor 3               2750              725        432

In the cube ,the population is loaded only once and it residesalways in say jul/2015.

But sales is for all months.

Now when we use a Months as a prompt, the population value goes off to empty when other months are chosen which is ideally correct, but I want this population value to be fixed.

I have the expression for population as Tuple([2015/July],[Population])
And my slicer for the months is
#promptmany('prmMonth','mun','[DistributorSalesCube].[Time Period].[Time Period].[Months]->:[PC].[@MEMBER].[' + timestampMask(_first_of_month($current_timestamp),'yyyymmdd')+ '-' + timestampMask(_last_of_month($current_timestamp),'yyyymmdd') + ']','set(','',')')#

Which is a macro for allowing user to choose multiple prompts.


My slicer overrides the population value. I dont want this to happen. I am not sure how to achieve this.Any help is appreciated.

Now I am able to report only on YTD but not on months, the population value becomes empty for all the months except july 2015

Thanks,

Hi,

Sounds like you need to use completeTuple() rather than a plain old tuple()

MF.

[cognos05]

I did it Yesterday, but I think I missed defining one value for a member, I rechecked again and it worked.

Was thinking of some good example to use complete Tuple and Here it comes :)

Thanks,
Nithya