how to perform a report with many dimentions? [message #302801] |
Wed, 27 February 2008 01:09 |
nadia74
Messages: 85 Registered: August 2007
|
Member |
|
|
Hi,
I've made a report in report 6i to show indicators which have six dimentions for example time dimention,geographical dimention, gender dimention,...
when i chose one of the indicator dimentions to show its values (to have the average, the sum,...)i have to send only one column to the query, my problem is that when i want to chose two or more dimentions i have to repeat the query in the report builder with the number of the chosen dimentions.
and also i want the report to show me the other values according to the others dimentions, to do this i've also to repeat the query in report builder with the number of the others dimentions.
is there any other way to do that?
regards
|
|
|
|
Re: how to perform a report with many dimentions? [message #308227 is a reply to message #302801] |
Sat, 22 March 2008 09:42 |
vhoffius
Messages: 1 Registered: March 2008 Location: Netherlands
|
Junior Member |
|
|
Hi,
I don't quite understand what you requirements are either, but what I usually do with complex reports is code what you need in a database function returning a tabletype. A function is often more easially to maintain than a report.
Regards, Vincent
|
|
|