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

Downdrill functionality

Started by BI-forme, 06 Apr 2009 07:14:28 AM

Previous topic - Next topic

BI-forme

Hello,

When using C8.4 I get the following problem:
When I use one query I enable the checkbox for downdrill in ReportStudio (Data -> Drill Behavior -> Allow drill-up and drill-down) and it works fine.

When I join two Query and enable the same checkbox, I can't drill in the report. Does anyone get explane this ?
When building the same report in C8.2 it works fine.

It looks like whenever I join / union a query, the drill functionality doesn't work.

Please help!

rockytopmark

Correct... Join Queries and Unions are relational techniques which indeed eliminate the Dimensional Drill-Down/Up functionality.

Join queries are not generally used in Dimensional Report authoring.  There is a Dimensional function to do Unioning.

Examine why you are doing a join in your report, and try to move that join back into your model, so that you can preserve your Dimensional drilling capability.

BI-forme

Rockytopmark,

Thanks for your reply.

Joins and unions and drill-down / drill-up works fine in C8.2, so I don't understand why it does not work in 8.4 anymore?
I use this a lot with dimensional models.


Can you explane more about "There is a dimensional function to do unioning"?

Thanks.

rockytopmark

From the attached document:

3.55 union
Syntax:
union ( set_exp1 , set_exp2 [ , ALL ] )
Description:
This function returns the union of 2 sets "set_exp1" and "set_exp2".
The result retains duplicates only when the optional keyword ALL is
supplied as the third argument.

Examples:
union(set([Camping Equipment], [Golf Equipment]), set([Golf
Equipment], [Mountaineering Equipment]))

union(set([Camping Equipment], [Golf Equipment]), set([Golf
Equipment], [Mountaineering Equipment]), all)