I am exploring BI Publisher. I have a data model containing attributes and measurements from OBI EE Subject Area. (The date model is based on SQL Query and not OBI EE Analysis.)
For example, Country, State, City, Year, Month, Day and Sales.
Based on the data model, I have created two Layouts, one giving all the above reporting elements in one 'Data Table'. The other layout, I wish to have to display sales summaries by the attributes with max. three attributes included per Table/Chart - all in a single layout grid.
The issue is, at least looking at the Tables, it does not create summaries of the Sales values. For example, if I remove Day from a Table, it still shows me 30 rows (for November). If I try to use custom formula 'Summation' on Sales, BI Publisher shows me a warning message giving reason 'the selected component does not support the aggregation function'.
How can I show proper summaries, please?
I think, probably, my question is not clear or this forum is relatively quiet.
What I thought that if I have a query (data model) and based on that, different views (layouts) containing details and summaries by a few dimension attributes, I should be able to design a single BI Publisher report containing these different layouts (tabs) using one single data model. However, what I am noticing is in case of summaries, esp., tables (Data Tables), summaries are not created on the fly. Is this an expected behaviour? Should I create different data models for summaries as well?
Please let me know.
Thanks and regards,
Thanks for your feedback. I am using online layout editor (as this seems to be easier for a newbie like myself). I am making little progress each day, and I can understand what you mean.
I have created a new group for Country (G_1: containing Country and Sales using aggregate function SUM) which I need to have summaries for. And this is working fine (sales by country). However, if I want to have sales by Year and Country (after adding Year to G_1 group), then again it's not giving the appropriate summaries (something is causing row duplication).
Thanks and regards,