AbstractWhat would the impact be on performance and memory/disk usage in SAP Analytic Cloud if we executed a data action, such as a currency conversion, and systematically increased the data volume until we reach 1 billion records?This blog hopes to ...
User storyYou are the administrator of an SAP Analytics Cloud tenant and you notice a growing number of PRIVATE VERSIONS in the system. You see the need for some housekeeping tasks to potentially purge old private versions which are no longer in use ...
Hi,
SYSTEM --> PERFORMANCE --> PRIVATE VERSION STATISTICS AND ANALYSIS
There is a dashboard which shows the status of the versions as either "active", "deleted", "inactive".
When does a version become "inactive" and does it consume less HANA m...
Use caseSpecific COST CENTERS plan on specific GL ACCOUNTS otherwise every cost center would see a comprehensive list of all GL Accounts in their input planning table and this is not always desirable. How can we restrict the GL ACCOUNTS that are plan...
SAP HANA Calculation views for delivering logic
A real game changer for delivering logic that would traditionally be delivered mainly via BW Planning functions with special focus on the planning type = formula (FOX code) is the ability to use calcula...
Hi Pradeep,I also downloaded the content this week and had a similar error. The widget would not load at all. I did a bit of debugging and found that the HEIGHT property is defined as a "string" and should be changed to a "integer". I changed this in...
I'm answering my own question: The total version size in number of rows is 863,115,516 but the active version only contains 133,780,956 rows so the difference is rows that have been deleted and these can be seen if you goto page 2 where it shows the ...
Hi Thomas,In the version size statistics there are two row count values, one for "Running total versions" and one for "Running total versions size" and I assume this means the number of versions e.g. 1 in my screen shot below and it's row size of 863...
Hi,You are able to do this using an Analytical Application and use the API for managing versions. Then you will be able to select specific versions and delete them if you want and there is also an API to show you if a version is "dirty" iow unpublish...