How to acheive master detail report relationship in Single canvas using DVD

A-91038

Summary

How to acheive master detail report relationship in Single canvas using DVD

Content

I am trying to create a Master Detail report similar to OBIEE in DVD.

 

 

To create a quadrant type report in a single canvas and to achieve the following requirements.

 

 

Let's take an example

 

 

Report name: Expenses Analysis

 

 

Let us assume we have Years, Period, Amount (Value) and Category as Attribute members.

 

 

If we select a particular year (say 2017) from the first quadrant, it should display all periods of the year in second quadrant.

Then if we select particular period (say June),it should display the respective year , month and corresponding

category (say,Employee expenses) in the third quadrant of same canvas.

 

 

Is it possible to acheive this in DVD. If yes, please guide me the steps

Gabby Rubin-Oracle

Hi 3234547 (you can change it to your name or a handle),

Have you looked at the 'use as a filter' capability of the viz? I should allow you to do that, it is on the context menu for the viz.

Regards,

Gabby

A-91038

Hi Gabby,

We have already used this functionality in DVCS.

But for our requirement,

By selecting a particular year on the first quadrant report ,the year should pass as filter to second quadrant report.

By selecting any Month on the second quadrant it should dynamically pass both the Year and Month as filter to Third Quadrant report.

Please refer the attached report screen shot for reference.

Regards,

Vaigunthan

Gabby Rubin-Oracle

Did this achieve your objective? (if the image below does not show, just click on the big white space...)

A-91038

Hi Gabby,

Thank you very much for your quick response.

Please find attached screenshot for your reference.

As per your solution by clicking on the years, years should pass as filter to second and third quadrant.

Then, by Clicking Rating, rating should pass as filter to first and third quadrant.

But we got stuck with this on achieving the same. Can you please guide us through the steps to achieve the requirements.

Gabby Rubin-Oracle

Hi Vaigunthan,

I believe the final outcome is the close (with one exception).

• Assuming the first quadrant chart have years, selecting a year will pass it both to the second and third quadrant.
• Assuming the second quadrant chart have months, selecting a month will pass the month to both first and third quadrant.

The final outcome is that third is filtered by both year and month. The difference from your requirement is that month was passed to the first one as well.

BTW, the image does not have months on the 2nd chart.

Regards,

Gabby