Relative Cycle Using a Cube

Previous Member

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

Björn Reuber

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

Previous Member

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

Björn Reuber

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

Previous Member

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

Björn Reuber

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

Previous Member

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

Björn Reuber

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

Previous Member

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.

Björn Reuber

do you have already a cube having the stock amount as mentioned in the table? or should this be also calculated.

Previous Member

Yes I already have a cube containing stock amount. It's just need to calculate the dynamic cycle amount.

Björn Reuber

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

Unknown

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

https://boardeducation.talentlms.com/unit/view/id:2149