If you are familiar with planning and budgeting solutions, I believe you would know that in BSO cube, we are able to utilize the out-of-the-box dynamic time series to report on YTD, QTD, etc. But ASO cube does not provide this dynamic time series. As the current cloud solutions support data map, smart push, groovy…
Since the ASO (Aggregate Storage Option) cube is able to aggregate data on the fly, you may leverage the ASO cube to process the aggregation. There are a few ways to move data from BSO cube to ASO: Data synchronization Data Map Smart Push @XWRITE Groovy rules Once you push data to the ASO side,…
As we know that Oracle released Essbase Cloud Service in March 2017. Since Essbase is in Cloud, we are able to use MDX to query and manipulate the multidimensional data from cloud now. I think it might be a good time to discuss MDX. Let’s do a quick intro about MDX. Just in…