In an ASO reporting cube, it is important to properly clear data before pushing or copying data. ASO does not work as a BSO cube which has the block concept. In a BSO cube, copying a #missing value is common. But in an ASO cube, it will do nothing when it comes to copying the…
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,…