Does anyone here knows how to use the cycle in time functions tab but using a cube? Relative offset can be done via data flow with relative offset in the advanced tab. But how about cycle?
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
I would very glad if you can make a small example within board if you don't mind. Because this is so confusing that i didn't find a way how to implement the dynamic cycle like offset.
Thank you very much for your help.
do you want to use the dynamic cycle only in a dataview, or can it be preCalculated using a DataFlow?
Maybe you can give us some details on your Business case, cause than we can also discus a diffrent approach
There's file attached in this post containing the explanation of my case. And there's a formula inside that you can see which cell is affecting which cell, and what cell doing what calculation.
You can download the file here
You can ask me anything if you have any questions. Thank you for your help.
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
For the offset, it has been done correctly. But what I need is dynamically offsetting and sum the values within a certain period.
For instance, current date is 11th of Aug 2018. I have stock amount starting from 21st of August until 30th of August 2018 (10 days). Each day is having 10 pcs stock amount. So, what I have is
sorry I dont exavtly what you mean with
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 don't want to use the YCV 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.
do you have already a cube having the stock amount as mentioned in the table? or should this be also calculated.
Yes I already have a cube containing stock amount. It's just need to calculate the dynamic cycle amount.
isn't the dynamic cycle amount not the YCV amount on the shifted day?
So you already have the result (if you shift hte current date based on the shifitng cube) and use this for only displaying one YCV value
There is a good video in the capsule design E-Learning section explaining cycle and offset. This may help spur some ideas.
XP04: - How to apply the Time Functions
Retrieving data ...