For example, users with limited vision might prefer to use Cognos Cube Designer because of accessibility features that Framework Manager does not offer. Some objects that are used when modeling dynamic cubes are not compatible with relational and DMR metadata. Such objects include: virtual cubes, parent-child dimensions, relative time dimensions, named sets, calculated measures, and calculated members. Differences when modeling with Cognos Cube Designer and Framework Manager Framework Manager is a mature product that has benefited from many years of iterative improvements to its user experience. View context diagram for modeling relationships.
|Published (Last):||15 December 2013|
|PDF File Size:||3.97 Mb|
|ePub File Size:||6.75 Mb|
|Price:||Free* [*Free Regsitration Required]|
The result of this function returns the member from the Year level as shown in Illustration 3. Illustration 3: Cognos Viewer showing the member returned from the Year level of the Time dimension This function can be used for any level within the dimension.
For example, you can use the Month level as shown below. However, it can still be determined by finding the latest period that has data for a given measure. For example, the Sales and Marketing cube sample has members in the Month level from January to December for the year , but only has revenue values up to July of as seen in Illustration 5.
Illustration 5: Crosstab report showing Revenue values ending in July of , but months up to December View image at full size In this example, July of would be considered the current period.
You can create a Current Period data item that uses the following expression to determine the current period based on the Revenue measure. You could also use currentMeasure in the expression, but you would need to ensure that it is the default measure of the crosstab or chart report and that the data for that measure does not go beyond the current period. Get the last month that has data. The tail function returns a member set.
In this case only one member is returned since the integer argument is 1. For example, you may want to display the current period and the same period from the previous year using the parallelPeriod function.
In this case, your Current Period data item must return a member since the parallelPeriod function expects a member as an argument as shown below.
DMR’s pros and cons
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 to 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. Database Add an indicator in time dimension column for the sake of query engine, which will be explained later Alter table [gosales]. RelativeTime Parameter varchar 10 , Value int insert into [gosales]. Please note that you can define more complicated table, such as begin date, and end date.
IBM Cognos BI – Using Dimensional Functions to Determine Current Period
In this case only one member is returned since the integer argument is 1. Create a new table to host relative time as below. Option 2 handles DMR relative time at framework manager level. In order to explain the drm, the following report is used. At the same time, create all relative time dimensions at dimension layer. It is most flexible solution, however, it request report authors to have good understanding of MDX functions.