DMR Functions in Framework Manager. «on: 18 Nov am». Hello Folks, I am working on Cognos BI version, I have created a DMR model. Hi khayman, Ya, I am new to dimensional functions. I have to add simple ancestor() and Bottoncount() functions. I create a data item is. Could you please suggest how to achieve this scenario using DMR model. * Regards, DMR Function to get Previous Year Data. 6. Answers. 0 . Cognos Analytics – How to Modify Filter Options for a Data Item Used in Filter Widget.

Author: Zuluzilkree Gogor
Country: Brazil
Language: English (Spanish)
Genre: Photos
Published (Last): 12 March 2005
Pages: 254
PDF File Size: 9.52 Mb
ePub File Size: 1.56 Mb
ISBN: 831-6-63696-400-6
Downloads: 17825
Price: Free* [*Free Regsitration Required]
Uploader: Tojagar

Hi with alternative 2, do I need to update the dates in the parameter map every month? Check list of all posts.

Even DMR and cube both belongs multi dimensional reporting, DMR based report does present some challenges for relative time. To explore the similar relative time functionalities in cube, this document is intended to provide three solutions to handle relative time, listed below: Option 1 handles it at database level: This approach is not flexible, as you need to add column into database, but it is very easy to use for report authors. Option 2 handles it at framework functtions level: Instead of creating column for time dimension, a relative time table is created.

When there is any change for relative time, you need to only add records.

At the same time, create all relative time dimensions at dimension layer. This approach is relatively flexible, and it is easy to use for report authors as well. Option 3 handles it at report level: Without applying funxtions changes in database and framework manager, you can dynamically figure out current date, and then apply MDX time functions to determine all periods as requested on the fly.

  GEMU 554 PDF

It is most flexible solution, however, it request report authors to have good understanding of MDX functions. In order to explain the concept, the following dnr is used. There are three relative time frames: The solution will be demonstrated by using Cognos version Option 1 handles DMR relative inn at database level. Add additional relative time flag columns in Time dimension, and update it on daily basis.

In this case, create additional three columns as. Create each time hierarchy for each individual relative time.

The roleValue() function – IBM Cognos 10 Report Studio Cookbook – Second Edition [Book]

All three relative time is mapped as below. When published, the package should be displayed as follows. Then bring all three highlighted members into report query or report. Option 2 handles DMR relative time at framework manager level. The main disadvantage of option 1 is funftions change database when adding a new relative time.

To resolve this issue, this option is to provide a solution without change time dimension. The idea is to create a new relative time table.

When changing relative time, you only need to add record s. Create a new table to host relative time as below. RelativeTime Parameter varchar 10Value int. RelativeTime values ‘CM’, RelativeTime values ‘YTD’, RelativeTime values ‘R13M’, The value is actually a month key.

Please note that you can define more complicated table, such as begin date, and end date. Add an indicator in both database layer and business view layer. Then make time filter dynamic based on relative time table. Create a query object to host Relative Time. Based on this query, you can create a dynamic functjons map. Now create each relative time as a separated dimension.


You can copy date dimension and then rename and adjust it. The key point is to define a cognoos for each relative dimension. For Rolling 13 Months. Another key pint is to define top level member, somehow you need to add a reference of date dimension, so that the query engine know to apply the filter of the used dimension.

When published, package looks as fellows.

End of Support for Rational Insight 1.1.0

Option 3 handles DMR relative time at Report level. The options above provide report user a clear framework manager model, however you need to change database or framework manager. This is a way to develop relative time based report without changing database and framework manager.

Please see query below. Get the set of members from cognoz Time dimension at the Date level. Filter the set of Date to find the members that have function for a measure you know only goes up to the current period, in this case Ij. Get the last date that has data. The tail function returns a member set. In this case only one member is returned since the integer argument is 1. Because the desired result is a single member, the item function is used passing 0 as its index value argument funcgions return only the current period member.

Returning a member is important if you want to use this data item in another dimensional function. Posted by Charles Yin at Petter Huseby January 23, at Newer Post Older Post Home.