nested crosstab issue

[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