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

nested crosstab issue

Started by PRIT AMRIT, 24 Oct 2012 06:28:33 AM

Previous topic - Next topic

PRIT AMRIT

Hi guys,

I have a crosstab report with 2 measures. When I create 2  different report with 1 measure then the report shows correct data.

However when I create 1 Crosstab by putting these 2 measures in crosstab column, the report shows wrong data for one measure......


Any idea what could be the problem?

Thanks!!

Prit

mtirpude

Hi,

The two measures you are using in a crosstab might be from different namespaces or folders. These two measures are from different fact tables from database. For this to work correctly, you need to have a conformed dimension(common dimension) which relates to both these fact tables. When you have the confirmed dimension, your query creates full outer join on these facts and applies a coalesce function in the output.

Regards,
Manish | +919673990644
www.infocepts.com | mtirpude@infocepts.com

PRIT AMRIT

In fact it is just 1 measure and derived as 2 Data Items i.e. [Measure 1] & [Measure 2].

As I said it works fine and shows correct result when I put these 2 Data Items ([Measure 1] & [Measure 2]) in two different crosstab reports.

But when I am trying to put these 2 Data Items( [Measure 1] & [Measure 2] in one Crosstab, then [Measure 1] shows correct result but [Measure 2] shows wrong result.

any clue?

mtirpude

Hi,

Want to check your individual queries and their tabular data and relationship between the two queries.
Let me know if you can show me your screen using team viewer.

Regards,
Manish | +919673990644
www.infocepts.com | mtirpude@infocepts.com