on 01-03-2017 2:53 PM
Dear experts,
The data of ours cubes will increase significantly, we have to know the best practices about the BW cube storage : weight, maximum record, dimensions, etc.
Today we are in this configuration :
We found just one documentation : http://help.sap.com/saphelp_nw73/helpdata/en/d1/468956248e4d9ca351896d54ab3a78/frameset.htm
What are the best practices ? And if we upgrade to netweaver 7.4 or 7.5 with SQL Server 2016, have we the same recommandations ?
Regards,
Goulwen
As I said, there is not really best practices. I've seen cubes with more than 100 millions records. It will depend on the performances of your queries (linked to the structure of the queries, the volume of data, your hardware, your system parameters etc.) and the expectations of your users.
Are the query performances currently acceptable ?
But, a 50 millions volume seems a good time for thinking about an archiving/deleting/partitioning strategy.
Regards,
Frederic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In this case, I will probably survey the performances of the queries on this cube and take actions if a degradation occurs or is expected to occur soon.
If you have to bring some modifications to your cube at a time, maybe it will be the time to think about partitioning it. If you have a multi-provider on top of it, it should not be too difficult.
Regards,
Frederic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Goulwen,
At the end, it all depends on the current performances of your queries, on your expectations and on the estimated growth of your cube.
Regards,
FCI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please check this thread.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.