Topic: Architecture for Oracle BI
I want to consult to skilled colleagues as it is better to make architecture for the type table:
1 Mesjats1 Summa1 Status1 Polzovatel1
2 Mesjats1 Summa2 Status2 Polzovatel1
3 Mesjats2 Summa3 Status1 Polzovatel2
4 Mesjats2 Summa4 Status1 Polzovatel2
In that that the totals on the user it is impossible to add complexity (?), but it would be desirable to solve questions like:
1. To receive the last total on 1 for each user and to add their totals.
In that case I thought to use different grouping on dimension, I as understand if there is a calendar it works as though to search for analytically maximum date and then the total to it. But I yet did not check. What nuances can be at such structure? It is a lot of simply such statuses and almost on everyone to calculate a separate index, and there not only the total, and still an amount and , seems to me not abruptly.
2. Still want, more difficult variant when it is necessary to find the last date on 1 on each user but so that was previous 2 and not is mandatory sequentially previous.
Here to me in a head came to hold separately only a field on necessary before. To statuses, but it certainly far imperfect variant:)
I will be glad to any help, can eat any articles on a similar subject, I unfortunately could not find. Well and generally if had experience with similar decisions how not to collect all rake?