Analytics Software

Hi frnds , in a process , i have been assigned an issue ,,,,below is the requirement given by my client


We need to configure the Budget Table in the RPD Side.

The granularity of this table is at : Customer Site Use Id -- Sales Rep Id -- Ent Period Id

Include the Budget amount, Budget YTD, Budget QTD in the Sales Order Lines/Invoice Lines

The Aggregation content should be at the Period Level.

Please note the difference, the Sales Order lines and invoice lines is at Day level, where as the Budget is at the Period Level

We will have to set the aggregation content accordingly.

i have a budget table in database and i need to import it to rpd , i need to give joins and copy the BUDGET_Amount column and create YTD , QTD for it and drop it in Sales Order Lines and Invoice Lines fact table .

This is what i understand .

Can some one out there please explain what is the granular level , and also about the above issue....


Thank you