This content has been marked as final. Show 2 replies
Unfortunalty BIP doesn't aggregate anything, like the BI server does. It will always show data on the lowest level.
If you use a query on the BI-server let the BI server do the aggregation and just remove the "Month" column. If you don't want to remove it from your OBI analysis, copy the logical SQL from this analysis to BIP. And select OBIEE as a datasource.
Then remove month from your query.
Thanks for your reply.
It looks like with using a pivot table (/cross table) instead of a table, data is aggregated correctly.