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

transformer automation - monthly filter question

Started by damzI, 08 Mar 2017 04:09:02 PM

Previous topic - Next topic

damzI

So I have a model file (project_######.mdl) with (all) data sources that have a prompt on month (yyyymm). The same prompt is to be used eveyr time.
I with one partitioned cube (projectcube_#####) in that model.
I have a automated script where I can log in with my credentials and the required month (in the yyyymm) format - and have the cube run successfully.

However - the challenge I am having is that I need that cube to have the month information only (projectcube_mm) - and not the year information.

Any ideas on how to work this.
Thanks, D