Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to develop this report/Query

Hi

How can i develop this report.

Our cube is loaded with Employee's Salarly on Monthly or Weekly basis (Some are on Monthly & some are weekly payroll)

Payroll date is defined as both CHAR & KF in cube

Data In Cube

Emp_ID---Payroll_Date--Amount

001


17.09.2008---2500

001


17.08.2008---2500

001


17.07.2008---2500

001


17.06.2008---2500

001


17.05.2008---2500

001


17.04.2008---2000

001


17.03.2008---2000

001


17.02.2008---2000

001


17.01.2008---2000

001


17.12.2007---2000

His Salarly is changed on 17.05.2008 from 2000 to 2500

Now my requirment is to develop a report which shows Employees Current Salarly and Previous Salraly(Changed) and Diff of change

for the above example the report output i am expecting is

Emp_ID--Current Sal (KF)Previous Sal (KF)increased amount--


Payroll Date

-001


2500
2000

500
--


17.05.2008

I am struggling to create this report ...

Please update how can i achieve this

Thanks

Not what you were looking for? View more on this topic or Ask a question