Tagged: modeling

Why a calculated column contained invalid (empty) values

When creating a calculated column (within an analytic- or calculation view) via the SAP HANA studio, unexpected behaviour was detected….after several hours of debugging. Herewith a small blog entry on what happened and how it was solved. After having extracted the VBAP (sales order items) table to HANA, this VBAP...

More

ProfitBoost – an innovative Ciber solution

Last year Joop Wilmer, Margreet Klerkx, Roel van Bommel and yours truly participated in Ciber’s (Netherlands) “So You Think You Can Innovate” competition with our GRiP (Generating Revenue Potential). After we’ve won the competition, we’ve hooked up with Ciber Germany and started, in close collaboration, with the build phase of...

More

SAP HANA: “Currency ViewAttribute finalAggregation (SAPDBTech 2048)”-error

When modelling, in close cooperation with Ciber Germany, our solution for the SAP HANA race in Walldorf, an error occurred when executing a query/report on our datamodel. No errors were detected while checking and activating the datamodel, but running a query on the datamodel generated the following error message: It took a while...

More

Get Connected at the SAP Analytics Forum

On the 28th of February, SAP Netherlands will be hosting an Analytics Forum.       On this forum Ciber will be presenting and demo-ing it’s GAPP (Generating & Analyzing Profit Potential) solution, which is a solid combination of SAP BODS, SAP Predictive Analysis, SAP HANA and SAP BO Explorer. For those living in The...

More

SAP HANA (Analytical view error) measure cannot be identified

After the creation of a new analytical view, via the SAP HANA studio front-end tool, I continuously got an annoying pop-up message, telling me that a “measure cannot be identified“. As this message was generated via a pop-up, instead of the regular job-log, no more additional information was shared. The...

More

SAP HANA academy

I’ve spent the time between Christmas and New Year not only for a retrospective on 2012, but also to create an application via the Hana Studio. Via the HANA studio I’ve created views, tables, analytical views, attrib views, calculation views and even several procedures 🙂 But, as to be seen...

More