cancel
Showing results for 
Search instead for 
Did you mean: 

Keep Flag property is not working as expected

0 Kudos

Hi,

I am working on HANA SP12 and testing Keep Flag property but it doesn't seem to be working.

At data preview I am dragging Product, Month, Quantity and Total_sales(which I am calculating as Quantity*PRICE1). I created Calculation view of type Cube without Start Join so the default node is Aggregation. When I add this table and set Keep flag for ORDER1 a True, not matter which dimension I select the background should always consider ORDER1 column in group by, which is the property of Keep Flag. But for some reason it is not working.

I read the below nice article but he brings in between aggregation node and Semantics, a projection node which i don't understand why. The keep flag should have been enough to bring ORDER1 into grouping irrespective of it being selected in select or not.

Can someone please help, If i am missing anything here. Aggregation node by default will do aggregation before calculation.

Accepted Solutions (0)

Answers (1)

Answers (1)

muthuram_shanmugavel2
Contributor
0 Kudos

Hi Nikunj,

Your assumption is correct.

//When I add this table and set Keep flag for ORDER1 a True, not matter which dimension I select the background should always consider ORDER1 column in group by, which is the property of Keep Flag//


I too tried CBA Scenario with my data in Calculation View.


Enabling Keep Flag in default Aggregation node is not working.


If I enable Keep Flag in Aggregation node and connect Aggregation node output to projection node,

It is working. I checked the Data Preview @ Intermediate level - Aggregation node, CBA is working fine.


Have you followed the same step suggested in the document Exception aggregation modeling with Graphical Calc view?

Else, Please follow the same step suggested in the doc.

Enable Keep flag for ORDER1 column in Aggregation node and connect it Projection node and

check the results.


Regards,

Muthuram

0 Kudos

Hi,

Thanks for your reply. And yes, I followed exactly the same steps as mentioned in the link, but what I am wondering with is that according to SAP document we need not require to bring in Projection node in between to have CBA in aggregation. By the way, where is this option CBA we can manually check. I thinks its handled internally, if not please let me know where do you see this option.

Also, at the intermediate level it is working fine when Projection node is checked above aggregation node, correct?

As I am checking there.