04-21-2011 10:11 AM
04-21-2011 04:31 PM
03-05-2013 09:07 AM
I'm faced with the same problem, which UlfB describes, and unfortunately, I was't able to find the suitable answer in Your reply.
As I understand it, incremental updates or updating in-place are the ways to add new data to existing cube, not to replace it.
Actually, I need to replace (or completely delete) only some portion of cube data without rebuilding the whole cube or creating a new generation of cube.
There is a way to do this?
03-10-2013 08:13 AM
To keep things simple, I refresh our cube data each month.
By refresh I mean (a) perform a physical cube data file delete, then (b) do an upload step, all using PROC OLAP.
Maybe you can explain why you need to keep the existing data while adding new data, instead of doing a full refresh?
We extract fresh datasets each month, so it's easier just to load that dataset than perform incremental updates.
03-10-2013 11:20 AM
Our cube is also supplemented by new data on monthly basis.
Each monthly dataset consumes about 80 GB of disk space and it's uploading with PROC OLAP ADD_DATA UPDATE_INPLACE statement takes 3 to 4 hours. So if we will try to make a reload data for a full year, it will take more than a day, and we need much more free space on disks to store the necessary data.
In my opinion this is not a good solution if we need to replace data only for the one month.
03-18-2013 03:27 AM
Maybe you could benefit from using a ROLAP strategy for storing the Cube data, which will let you do updates using standard data management tools (SQL, data step etc).
03-18-2013 10:11 AM
Thanks to all for replies.
I also came to conclusion that a ROLAP aggregations would be the better solution in this case.
But all the same, is there a way to delete a portion of MOLAP cube data without full cube rebuilding?
In accordance with SAS(R) 9.3 OLAP Server: User's Guide: "SAS MOLAP aggregation storage maintains the cube data in the same table format as the format that is used by the SAS Scalable Performance Data (SPD) Engine."
May be it is possible to assign a folder which contains cube data as a library through SASSPDS Engine and then update it directly?