Skip to Content
0
Mar 04, 2014 at 04:31 PM

How to model scenario in HANA

673 Views

Hi All,

We have a scenario described as below:

Summary DSO

Cost center Period/Yr Amount Order

C1 001/2014 100 O1

Line Item DSO

Period/Yr Order Prev Order Amount

001/2014 O1 O2 60

001/2014 O1 O3 40

001/2014 O2 O4 30

001/2014 O2 O5 30

001/2014 O3 40

Our final requirement is as below:

Cost Center Period/Yr Order 1 Order 2 Order 3 Amount

C1 001/2014 O1 O2 O4 30

C1 001/2014 O1 O2 O5 30

C1 001/2014 O1 O3 # 40

Need about 6 iterations of line item DSO to get 6 order level

Each of the above DSO's have about 100 Million records and we would need data for atleast 2 years in report

We were thinking to do this as part of on the fly reporting using calculation view with a SQLScript as below :

- create Attribute views joining to two DSO's and get the first iteration

- SP with sql on the Attr view to get basic data set

- then additional join to Line item DSO to get further iterations

- Planning to put the sql in Calc View

Concerns

1) Performance wise calculation view via sqlscript does not give good results

2) CE functions - unable to use them much since we would have to store intermediate results in tables. This causes out of memory dumps due to large volume

Please provide your thoughts or views on best to model such a scenario in HANA. Appreciate your help!

Regards

Vidya