Relative Cycle Using a Cube
Hello Everybody,
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?
Thank you.
Regards,
William
Answers
-
Hi,
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
regards
Björn
0 -
Hi Björn,
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.
Regards,
William
0 -
Hi,
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
regards
Björn
0 -
Hi,
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.
Regards,
William
0 -
Hi,
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
Regards
Björn
0 -
Hi,
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
- I have a cube for offsetting the current date, to 30th of August. So that offset cube is containing 20 (offsetting 11th to 30th needs 20). This can be done easily using dynamic offset in data flow.
- 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). I haven't found a way to implement this in BOARD.
Any ideas?
Thanks
Regards,
William
0 -
Hi William,
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):
Current Date Offset Current Date with Offset Stock Amount Stock Amount YCV 20180809 20180810 20180811 1 20 20180812 20180813 20180814 20180815 20180816 20180817 20180818 20180819 20180820 20180821 10 10 20180822 10 20 20180823 10 30 20180824 10 40 20180825 10 50 20180826 10 60 20180827 10 70 20180828 10 80 20180829 10 90 20180830 10 100 20180831 1 Total Aug 100 0 -
Hi,
It almost correct. It should be like this: Current Date Current Date with Offset Cycle Value Stock Amount Dynamic Cycle Amount 20180809 20180810 20180811 20 10 20180812 20180813 20180814 20180815 20180816 20180817 20180818 20180819 20180820 20180821 10 20180822 10 20180823 10 20180824 10 20180825 10 20180826 10 20180827 10 20180828 10 20180829 10 20180830 10 20180831 10 100 Total Aug 110 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.
0 -
do you have already a cube having the stock amount as mentioned in the table? or should this be also calculated.
0 -
Yes I already have a cube containing stock amount. It's just need to calculate the dynamic cycle amount.
0 -
Hi,
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
regards
Björn
0 -
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
0
