Calculated Column Issue

[vivekbhoj]

Hi Everyone,

I have a table with millions of records.

I have created a simple Calculation View with one Projection Node and some mandatory input parameters like Period, Year, Company Code and Controlling Area.

The View has more than 150 measures and 20 attributes.

After entering all the parameters, the result comes out in 15 seconds.

The Plan Viz looks like this:

Why Self Join is performed on the table?

Now when I create a Calculated column in the Projection, the report takes around 1 minute 30 seconds to display the data.

The Calculated column is pretty simple.

It just shows description for the Transactions:

case("COPA_AWTYP",'BKPF','Accounting document','COBK','CO Object: Document Header','COPA','COPA','KE28','Top Down Distribution','MKPF','Material Document','RMRP','HR Data of Repetitive Manufacturing Backflush','VBRK','Billing Document','')

and after seeing Plan Visualization I found out that for a particular month,there are around 34 million records but later on after calculations and grouping, there are around 900 million records being created

What could be the possible reason for this?

Because of this CPU and Memory Utilization is very high.

Regards,

Vivek

[former_member182302]

Hi Vivek,

Create that calculated column in the Aggregation node at the end instead of Projection node. That should definately save some time.

Regards,

Krishna Tangudu