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

RESOLVED: Create Set based on Prompt

Started by adam_mc, 08 May 2014 01:19:51 PM

Previous topic - Next topic

adam_mc

I am hoping this is really simple and I am missing something really obvious....

Dimensional using Transformer Cube.

I have a 2 multiple selection prompts each to select a Groups of Stores (prompt is at Store Level).
Parameters are p_TestStores and p_ControlStores

I simply need to create two member sets of Stores (TEST and CONTROL) and place as Crosstab Column Headers.

Any help would be greatly appreciated.
Thanks in advance,
Adam.

adam_mc

Issue resolved... knew it would be simple.

Created two calculations

set([Stores] ->?p_TestStores?)
set([Stores] ->?p_ControlStores?)

Then used aggregate(currentMeasure within set ([New Calcs]) to get what I needed!