1.You can add budget date into fact table
Add Budget data into firstday of every month;
2.You can create two cube,one contains fact data,another contains budget data.
Cube(Fact)
Cube(Budget)
At Cube Fact,you can create a command to get budget data from Cube Budget using function...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.