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