Issue with Calculation view - Joins takes more time in Data Preview

[former_member462348]

Hi Experts,

I have issue with my Calculation view, Where I have a table CRMD_PARTNER which stores the partner details of a document. And now I want to display all the partners in HANA in different Column.

Like Below

Sold to Ship to Bill To Payer

Some document even has 8 to 10 Partners information. So i tried implementing in Calculation View like below image, but when fetching the data for the PARTNER_5, my Join_6 was keep running for 3 to 4 minutes. Where as for the preceding Join_5 was taking only 8 seconds to display the data.

I have created 5 different Projections with Different Partner Function filters in it. An still have to create 2 more projections with different partner functions.

Seek your support in achiving this.

Thanks
Rufus Samuel

[developerone]

Can you provide more information on your joins ( type of join and cardinality). Does your base projection, Projection_1 filter all the 5 partner functions? Also, I'm unable to understand the purpose of Join_2. If you can name them in an understandable format and add some comments on what each join is doing and the filters applied at each level it may be easy to analyze.

[former_member462348]

Hi Sai,

Projection DOCUMENTS_TABLE: Am fetching ALL the Documents from CRMD_LINK table which acts as the main source of data.

Projection ALL_PARTNERS: Fetching the needed Partner information from CRMD_PARTNER table and have applied all the 5 Partner functions like Sold To Party, Ship To Party, Bill To Party, Payer, Contact Person for the field PARTNER_FCT. so basically one filter with 5 different values.

Segregation of filters to Different projections:
Projection ONLY_SOLD_TO: This projection has only ONE FILTER in it which is Sold To partner Function filter, so the resultant join_2 brings me Document Number with Sold to Party information.

am repeating the same logic for other projections like ONLY_SHIP_TO, ONLY_CONTACT_PERSON, ONLY_BILL_TO,ONLY_PAYER.

So my join works really fast till Join_4, where as executing Join_5 it takes more time like 3 minutes. You can see in the snap where am using only Left outer joins and tried applying cardinality but still there was not effect in Join_5.

Let me know whether this is clear.

[former_member462348]

Hi Poonam,

Thanks for your inputs.

But already i have applied the same filters which you have recommended and we need to show the Partner information in Different columns and not in rows.

If I go with join, then the partner information will be displayed in multiple Rows. Example: if my document is having 5 partner details. Then I need to display those 5 partners in 5 different columns. Hence I have used Projections here.

Can you please provide some snap or more detials of how you achieved this ??

Thanks
Rufus

[deodutt_dwivedi]

Hi Rufus,

Run the visualisation plan for your calculation view, it will help you in understanding the no. of records being processed at each node if the joins are causing any problem. Certain partner functions can have multiple records maintained and thus may inflate the total no. of records overall. In our case earlier we used to bring only one value per Partner for a particular customer to avoid redundancy.

Regards,

Deo

[former_member188770]

Hi Rufus,

We had similar requirement and we have implemented the same using following logic

1. Projection on CRMD_ORDERADM_H (put filter on bustype if required)

2. Projection on table CRMD_LINK filter OBJTYPE_SET =07(partner data)

3. Join the above 2 tables

4. Join with CRMD_PARTNER table (put specific filter type for partner function).

we have created join with CRMD_PARTNER table (with filter for partner function) for each partner function, instead of creating projections (the way you have done).

Hope this helps.

Thanks,

Poonam