Question:
Hi,
Call for data modeling experts
for our requirement we need to display the report in Fi /AR
------------------Payments
cusotmer----Advance---correct----Late---Total
C1--------------10---------30--------1------- 41
Advance = ( Clearing date - Net due date ) < 0. Result 0 if 0 else 1
Correct = ( Clearing date - Net due date ) = 0
Late = ( Clearing date - Net due date ) > 0
we dont need to display the document number.
we did the fresh data modeling for cube and ODS (to achive overwrite)its working fine only if i include document nummber.
----------------------Payments
cusotmer---Doc---Advance--correct---Late---Total
C1-----------1--------0----------0--------1-------1
--------------2--------1----------0--------0------- 2 ( 1+1 )
Result-----------------1----------0--------1-------2
but we need summarised information , when i exlcuded the document number in result area ,reports DISPLAYING 0.
Cusotmer ---- Advance---Correct---Late
C1----------------0-----------0----------0
is there ANY chance to display this line item with out Doc number in report ..?
I created custom cube with just CustOmer and Total records and Days ( Adv + Correct + Late payments ) .
but in report am unable seperate total records into how many advance , correct , late payments from days because this charecter.
if i choose Days as Key Figure its summing up as property of cube , this is not we needed.
I tried to keep data in ODS which is overwrite mode for Days and its giving 0 records for Only customer and Total records.
If i include document number its working fine , but we dont need doc no.
We knew we can achive this using update routines moving Advance , CoRrect , Late records into custom info objects, but report become static.
we are not ready to implemen this , we need create diffrent queries for
to find out 10 days late , 20 days late payements too
Any data modeling expert help me please.
cheers
martin
Answer:
Crystal Reports.
Answer:
I think you can try to make the calculation as a calculated KF, and force it to make the calculation at document level.
Two solutions :
1 - the cube is at document level : just create a calculated KF before aggreggation
2 - the cube is at document item level : create a special formula variable, forcing the calculation at document level and create your calculated KF after aggreggation, adding this formula variable.
Let's explain the 2nd solution : you can create a formula variable, named a reference value variable, a replacement path variable referring your document, and replaced by special attribute named "characteristic reference'. This forces BW to go down to the document level, and creates a "between after and before aggreggation" calculation.
Just multiply the formula you described in your post by this formula variable.
I hope this will work, I didn't check this particular case.
Please let us know if it works.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.