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

Family Functions in DMR

Started by kado, 09 Dec 2010 05:14:52 PM

Previous topic - Next topic

kado

Hello,

I am trying to use some family functions (lag, cousin, descendants, etc) with a DMR model I've built and getting all sorts of errors. Is this because these functions are MDX based whereas DMR is not?

My current challenge has to do with YTD whereas I have a user that only wants to see YTD through the last full month .... so something like: LAG([YTD], 1)

I tried to just filter out the Current Month but still not having much luck.

Any thoughts?

thanks,
kado

cognostechie

You can definately use those functions with a DMR. It does work including LAG function.

Unlike Transformer, DMR does not automatically build relative time categories so it depends
on how you built those. There is a way though.

Have you tried a more dynamic way? Put prompts for Time Period (Months) and let the user select
which Year/Months they want to see and show data for only those months. You can do this with a combination of 'intersect' and 'lastperiods' functions.

You can also show data for relative months of prior year with 'parellelperiod' fucntion.

MFGF

Quote from: kado on 09 Dec 2010 05:14:52 PM
I am trying to use some family functions (lag, cousin, descendants, etc) with a DMR model I've built and getting all sorts of errors.

Can you give us an example of the expression you are trying to use and the errors you are seeing?  You should be able to use all the normal MDX functions against a DMR package, so there's obviously some other issue somewhere...

MF.
Meep!

kado

Good feedback! I tried to allow my users to only select 1 month and then have the report do the YTD but giving them the ability to pick multiple months makes it that much more dynamic.

Yeah, I assumed those functions should be available in DMR and must have some other issues I need to work through.

THANKS for the thoughts and feedback!!!

cognostechie

You are very welcome ! I am happy I could help  :)