I haven't use intervalmatch. Can you add some data in the inline in the application whivh I have attached. and let me know the calculations you want to do
We have implemented several large application containing complex p&l, balance sheet and cash-flow statements and al of them we have done using the interval match process mentioned in the technical brief. If you follow the directions in the document you should be able to get your report done
i dont have fields like Exec P&L Level and Exec P&L Calculation and ExecPLStart and ExecPLEnd
and Reporting Code also. shall ask DB admin to insert these fields. and i studied that document. but i cant able to understand how its calculating NET SALES. is it based on ExecPLStart and ExecPLEnd. can you tell me how its calculating?
You do not need to necessarily have such fields. I'm guessing your account names already exist in the database? create a mapping table which will contain unique ids for each account.
ACCOUNT A/C ID
Gross premiums 1
RI Share of premium-FAC & Prop. TTY 2
XOL Protection costs 3
no create another table which will contain your your report format
report header report_start report_end
Gross premiums 1 1
RI Share of premium-FAC & Prop. TTY 2 2
XOL Protection costs 3 3
Net Premium 1 3
Once you do this and do the interval match you can use report header in your straight / pivot table as dimension and sum(Amount) or other similar expression.
Is the amount that needs to be subtracted already negative ? otherwise you can multiply by -1. For example when we did the p&l we created flags in the script which later helped us identify which filed values to addd and which ones to subtract
doesn't necessarily have to be inline..you can load from excel. For the report ids we created mapping tables inline then mapped it to the data we loaded from our database
