Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Introduce a dynamic rank function based on user selection of calendar periods

    To Introduce a dynamic rank function based on user selection of calendar periods (one each for Current Period and Prior Period) and the ranking of a dynamic changing weighted average costs meas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

I think your calculation is based on your data model. Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Rico,

Thanks for your response.

Please find the below sample data

F_WRIN_SUPPLIER_CSA_COST table:

idxCATEGORYSUPPLIER_IDWRIN_IDCOST_TYPECOMPONENTCOMPONENT_TYPEUOMCOST_PER_UOMUOM_QTY_SHIPPEDTIME_PERIODSUPPLIER_RANKTIME_FRAMETIME_TYPE 
47526BUNSUPPLIER_19182WRIN_00001621FOBUTILITIESCONVERSIONDZ$0.02540Actual12021-07-01Monthly 
47514BUNSUPPLIER_19182WRIN_00001621FOBUTILITIESCONVERSIONDZ$0.02540Actual12021-10-01Monthly 
47502BUNSUPPLIER_19182WRIN_00001621FOBUTILITIESCONVERSIONDZ$0.07310Actual12022-01-01Monthly 
47550BUNSUPPLIER_19182WRIN_00001621FOBUTILITIESCONVERSIONDZ$0.02542,11,59,120Actual12021-01-01Monthly 
47538BUNSUPPLIER_19182WRIN_00001621FOBUTILITIESCONVERSIONDZ$0.02542,25,21,456Actual12021-04-01Monthly 

 

Wrin_prefix table dim

idxWRIN_IDPREFIX_ID 
166WRIN_00001621PREFIX_00001 
    
    


Prefix table dim:

 

idxPREFIX_IDPREFIX_ALIASPREFIX 
0PREFIX_00001100001-REGULAR BUNS 

 

Supplier table Dim:

idxSUPPLIER_IDSUPPLIER_ALIASSUPPLIER_NAMESUPPLIER_PARENT_NAMESUPPLIER_ZIPCODESUPPLIER_CITYSUPPLIER_STATESUPPLIER_COUNTRYTIME_ZONEREGION
24SUPPLIER_191821918219182-Foods INC.FOODS, INC.27520CLAYTONAustinUNITED STATESEastern Standard Time (EST)EAST