Topic: Oracle BI 11g, aggregation on two fields
Help, to understand with an aggregation question on two fields in the cutoff table.
In data domain there are fields: region, service, kpi, weight and some more fields with indexes. It is necessary to make the cutoff table in which regions are transposed in columns, services at lines, intersection of lines and columns - kpi.
Such table to construct it turns out.
But here with totals it is not got on. On each region in totals it is necessary to do not simply aggregation on kpi, and aggregation on kpi * weight.
Tried to do in section for services a new calculated member in which to do aggregation for kpi * weight but as them there correctly to specify I do not understand.
I will add, the data domain is constructed on a basis pipelined functions. And its data is used also at creation of one more table in other section. To write one more pipelined function for an output of the necessary aggregates on kpi * weight I think it is inexpedient, since great volume of the data from several DB will be repeatedly scanned. It would be desirable to use results of one function for creation of two tables of sections with various aggregations.