Drill down reports in FC

[rrbo]

Is that possible to drill down ...from the summarized tables having each total column differently.. The relationship is being made as snowflake...from top level to bottom level.

I want to extract the value (total column) from top level table1 .....dynamically on selection and drilling down to the next dimension. Is this possible?...No aggregations to be made when projected.

The relationship between dimensions are like as
country region
total total
country .....like..etc.

Any help would be greatly appreciated.

I have tried with @aggregate_awareness... ....
when I am drilling to next dimension...result being cartisian.
I have checked all joins...(its ONE-TO-MANY).

Can anybody advice..on this..pl
Thanks in advance,
Sri

 

[Sridharan]

Oops : one more Sri out there!!!

Sri

 

[rrbo]

Hi Sridharan...

U do not have any solution...for the abv question???

Great!!....Thanks...
Sri