@Year_Selection

Previous Member

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.

Find more posts tagged with

Usage

Accepted answers

All comments

Helmut Heimann

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

Previous Member

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

Daniele Di Lorenzo

select 2018

data flow

a: Cube A refer to year 2014

b: Cube B = a

Previous Member

Hi Daniele Di Lorenzo,

Cube A contains 9 years Data starting from Year 2010 to 2017.

Please suggest how to restrict that.

unknown

Hi Daniele Di Lorenzo,

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

Helmut Heimann

Hi ABHIJAT SINGH,

you would need the reference tab of the source cube in the dataflow:

Helmut

Helmut Heimann

that would have to be done via another cube for selecting the appropriate members of the year-entity

Previous Member

Hi Helmut Heimann,

Unable to run the process as it is taking too long to process.

Helmut Heimann

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

Previous Member

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

Previous Member

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.