@Year_Selection
Problem Statement-
(a) Cube A contains Data from year 2010 to 2018.
I want to plan for year 2019.
My Selection contains reference data from year 2014 and I need to copy it in year 2018?
Please suggest how to achieve it.
Answers
-
Hi ABHIJAT SINGH,
a select in a dataflow determines the selection on the target. Thus, you'll have to select "2018" first and your source cube needs a reference to 2018-4; using the appropriate offset.
That'll do the trick.
Regards,
Helmut
0 -
Hi Helmut Heimann,
Just simple, I want to copy data of year 2014 to year 2018.
My reference cube contains data from year 2010 to 2017.
how to restrict offset like -730 to -365, don't wanna data of current year? just want data of previous year
0 -
select 2018
data flow
a: Cube A refer to year 2014
b: Cube B = a
3 -
Cube A contains 9 years Data starting from Year 2010 to 2017.
Please suggest how to restrict that.
0 -
What if the user want to copy any year of data(dynamic) from one cube (cube A) to any other year(dynamic) into another cube (cube
then how to do that..?Thanks
0 -
0
-
that would have to be done via another cube for selecting the appropriate members of the year-entity
1 -
0
-
Hi ABHIJAT SINGH,
as long as I don't know anything about the
- data volume
- structure of source- and target-cube
- definition of your dataflow
I won't be able to help out here.
So it would be nice if you'd provide some more information on these topics.
Kind Regards,
Helmut
0 -
0 -
Hi Helmut Heimann,
I have attached the screen shot for each step, in my expected output I am getting output as- input*365
as 365 being my number of days
Regards
Abhijat Singh
0 -
The refer to function is very inefficient when used in dataflow and, due to your cube structure, the refer to "year" copy the value of full year in each day of 2018!
You have to use instead the offset function
This is a static function: user can not change the offset without edit the procedure.
If you want make it dynamically you can try this way:- Create a TMP cube with a fake dimension
- create a dataview with this cube where a user can write the number of day from 2014 to 2018 (365*4 plus 1 for leap year)
- select year 2014
- dataflow c=a with relative offset Forth by the fake cube
See board manual below for complete information Procedure actions reference \dataflow
The Dynamic Offset is a function of the DataFlow used to shift cube values on the time dimension. The shift can be absolute, based on a specific date (Absolute Offset option), or relative (Relative Offset option), shifting values forward or backward for a given number of periods as specified by another cube.
The Dynamic Offset function is located in the Advanced tab of the setup.
Based On: set the cube that defines the offset .
Relative Offset: Shifts cube values forward or backward in time based on the number of periods specified in the cube set in the Based On field. The time shift can occur either forward (Forth option) or backward (Back option). To use the Relative Offset option, the Based On field must contain a cube containing integer values.
2
