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

How to use parameter map in cognos cube designer

Started by GeethaKL, 05 Jun 2023 09:13:22 PM

Previous topic - Next topic

GeethaKL

Hello All
I am working on Cognos Analytics 11.2.4
I am designing Date Dimension and have to create Relative Time.
and I dont have current period in my dim date table.
My DBA has created a separate table DIM Control Date table to get the data based on Data processing Date happening every Friday..

My thought is to create a Parameter map and then bring it to Calendar Date level in my Calendar Date Hierarchy(Year, Year Month , date levels).

I am able to create Parameter map for current period from Control Date table but dont know the correct syntax to use it in my Calendar date level(Date Dimension).

please someone point me out in the right direction on How to use Current Period Parameter Map for Date Dimension in cognos cube designer.

Regards
Geetha

bus_pass_man

I'm not entirely convinced that the approach that you are envisioning is possibly the optimal one.

Cube designer has a fair bit of relative time functionality, which will automatically generate relative time members, built in. You would do that by defining in a property of a level the member key of the member of the level which you want to be set as the current period member. It does not require a column to be explicitly defined as current periods.

You can customize it too. 

You would need to re-publish and restart your cubes each time you change the current period so that the member cache can be regenerated with the appropriate relative time members.

I'd invite you to read the redbook and the documentation. 


https://www.redbooks.ibm.com/abstracts/sg248064.html

https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=dimensions-custom-relative-time-members