This document provides additional detail and examples of the dimensional functions provided within Report Studio for Cognos 8. 1.2 Applicability The functions and sample data listed below apply to Cognos 8, Report Studio. The PowerCube and deployment package for “Great Outdoors Company” are provided with the product samples. Dimensional Functions. Ancestor Returns the ancestor of 'member' at 'level' or at 'integer' number of levels above 'member'. Note: The result is not guaranteed to be consistent when there is more than one such ancestor. This is most often used as a placeholder during development or with dynamic report design (either with the IBM® Cognos. Date Functions - Download as PDF File Report Studio. Cognos Time and Date Functions CAST and EXTRACT Where IBM Cognos Report Studio Fundamentals - Student Guide Avoiding Query Macros. By selected date, We have discovered that macro code syntax help is not readily available for IBM Cognos Report Studio developers.Date Functions to Convert a Date. Filter function in dimensional report Cognos 10.2.1. Tech Sign In Page Forgot Password? Don't have an account?

1. Cognos Rank Function Examples
2. Cognos Cast Function

IBM Cognos BI Dimensional Functions. Published on July 21, 2009 / Updated: February 25, 2011. Get the download. Guide for IBM Cognos BI regarding the steps to restore and configure these samples. A deployment file called Dimensional Function Samples.zip contains sample reports and was created with IBM Cognos 8 MR1. It is bundled in the. This page provides links to PDF versions of the IBM Cognos Business Intelligence 10.2.1 and 10.2.1.1 product documentation. Data Manager Function and Scripting.

Hi,
I am creating a dashboard with several reports in it using 2 filters: ?Year?, ?Month?
Each filter uses ID as a value.
Year = Year_ID
Month = Month_ID
These filters come from 1 hierarchy. It's Calender.
The reason why i am using ID as a value, instead of MUN, because i need these filters can be used in several contents of dashboard.
For first report, i make this data item called 'Month':
item( filter([Business Revenue Analysis].[Invoice Date].[Calendar].[Month],[Business Revenue Analysis].[Invoice Date].[Calendar].[Month].[Year Month ID]= concat(concat(?Year?,'0'),?Month?)),0)

Note: [Business Revenue Analysis].[Invoice Date].[Calendar].[Month].[Year Month ID] is an attribute.

It returned error GEN-ERR-0016 The 'ces_concatenate' function is not supported in the context in which it is used.

I've tried to change any pattern possible for concat, like or + but the result was still the same.

Then, i tried to create data item called 'DataItem':
?Year? + '0' + ?Month?

And i changed 'Month' into:
item( filter([Business Revenue Analysis].[Invoice Date].[Calendar].[Month],[Business Revenue Analysis].[Invoice Date].[Calendar].[Month].[Year Month ID]= [DataItem]),0)

But it still gave error QE-DEF-0478 Invalid coercion from 'memberSet' to 'value' for '[DataItem]' in 'item(filter(members([__ns_0].[Invoice Date].[Calendar].[Month]),[__ns_0].[Invoice Date].[Calendar].[Month].[Year Month ID] = [DataItem]),0)'.

Personal life [ ] Allen is. Black widow 2010 krista allen. On September 14, 1996, she married Justin Moritt, a production manager and producer. Allen had a T-shirt line called Superexcellent for several years.

I've been trying a whole day for this, and negative..
Any helps will be so much appreciated!

Regards,

Abednego Santoso

This content is no longer being updated or maintained. The content is provided “as is.” Given the rapid evolution of technology, some content, steps, or illustrations may have changed.

Updated February 25, 2011. The functions and sample data listed below apply to IBM Cognos BI Report Studio and Business Insight Advanced. The PowerCube and deployment package are provided with the product samples. Please see the Installation and Configuration Guide for IBM Cognos BI regarding the steps to restore and configure these samples. A deployment file called Dimensional Function Samples.zip contains sample reports and was created with IBM Cognos 8 MR1. It is bundled in the download zip file for this document.

In this article

Topics covered include:

• Function Definitions
• Function Grouping
• Deployment of Function Samples

Downloadable resources

• Article contained in ZIP file (Cognos_BI_Dimensional_Functions.zip 263KB)

Cognos Rank Function Examples

Related topic

Cognos Cast Function

• Cognos Business Intelligence and Financial Performance Management: Learn more about Cognos software, services, best practices, and support.