in normal Layout the Cycle can only be used by a fixed value and not dynamic by a cube.

Cause in DF its based on the source cell and the target can be outside of (a) the selction and (b) will sum up

Having said this I'll try to explain using a small example two cells with a different offset can have the same destination cell.So in this cell the data is summarized. For a front end funciton this would be very confusing

I hope this helps you.

If not, please let me know, than I try to create an example within board

couldnt the see the formulas behind the sheet. but maybe my application is also helpful:

Got three cubes Deliver , Offset and Prd Date. So when I need to deliver at 7.2 and need 10 days I have to produce on 28.01. . User can type on Deliver Date and Offset

With a simple procedure the data is written to the third cube. This can't be done dynamic in frontend, so you allways need some kind of calculation. As you also can see the figures from 7.2 and 9.2 are written to the same day cause of the different offset

And I will have another cube containing 10 (for summing the stock amount from 21 until 30th of August, 10 days back, so the total will be 100).

For which date this cube contain the 10? I tried to make an excel File with all the information, but I think some information is still missing (dont know maybe you only need a YCV or similar board function):

I want to get the 100 value on 20180831. 20180821 until 20180330 is 10 days. So I should set the cycle value to 10. And that 10 value for the cycle value is stored in a cube. So the user can set the amount of cycle dynamically. In my example, if the user set the cycle value to 11, then the dynamic cycle amount will be 110 instead of 100, if the cycle value is 9, then the value on 20180831 is 90, and so on.

Contact BOARD

Discover BOARDVille

Follow us

BOARD is an all-in-one
Corporate Performance Management and Business Intelligence software solution that makes it easy to build any
business analytics and planning applications without coding. BOARD offers all the
functionalities, tools and analytic capabilities needed to quickly create
dashboards, reports and self-service analyses fully integrated with
enterprise planning and simulation processes. BOARD is included in Gartner's
“Business Intelligence & Analytics” Software Vendors and “CPM Suites” Magic Quadrants. Recent comparison reports have rated
BOARD the best product for Overall Customer Satisfaction among a
comprehensive list of BI and CPM software vendors. Compare our customer list and case studies to discover more about the benefits of the best in class decision making platform.