Skip to Content

Keep Flag property is not working as expected

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.

Exception aggregation modeling with Graphical Calc view

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

Keep_Flag.jpg (80.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 20, 2016 at 12:41 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.