Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Joining Aggregated Data
Migrateduser
Hi, I hope someone can help as I have thought through various ways to do it, without any outcome so far.
I have two joined data sets A and B which both contain a column account_id. A and B are each a joined data sets as A contains all sales for an account_id joined with a rev share value from another data source (xls) in order to calculate the revenue. Hence, an account_id can have several sales in data set A.
Data set B contains all cost items of an account_id joined with another data source for the price of the cost.
I now want to bring revenue and costs of an account_id together. Naturally I would aggregate revenue and costs by account_id and then join A and B on account_id, however the dilemma:
aggregation seems to be only possible in data cubes --> data cubes cannot be joined
aggregation is not possible on a joined data set level --> data sets can be joined
I can't do it in the sql statement of the data set, as I need to join a given data set on individual revenue and cost item with another xls data source before.
how to approch this?
thanks a lot
david
Find more posts tagged with
Comments
There are no comments yet