Skip to Content
0
Former Member
May 08, 2013 at 10:52 AM

issue on aggregates

20 Views

Hi BW gurus

I have a infocube on which i have created aggregates,I read that when we create aggregates and do reporting on the infocube the data will be fetched from the aggregates but the data is populated from the cube in reporting.Please guide me how to get the data from aggregates

ex the data is

custno mtno country rev

c100 m100 US 1000

c100 m200 US 2000

c200 m200 INDIA 3000

c400 m400 AUS 4000

if i create an aggregate based on country and when i check in the menu option aggregate data in the aggregate screen

the output is

country rev

US 3000

INDIA 3000

AUS 4000

But when i execute a report on the cube it is getting all the data from the cube.How to get the report data based on the aggregate i have created.

as i was expecting that if i make a query on the infocube the data will be like

custno mtno country rev

c100 m100 US 3000

m200

c200 m200 INDIA 3000

c400 m400 AUS 4000

but the report is fetching data from the infocube and not from aggregates.Please guide me on this

Regards,

Sivarama