EPMCopy Range Issue

[Former Member]

Hi BPC Experts,

I have been used  EPM Copy range function many times and worked fine.

But now it is behaving so weird and i am not able to trace the issue. Let say I have applied yellow color on Column "C" & "G" but it is applying on next cell to it? So instead of applying on C and G column it is applying on D and H column.

Please let me know if anything is wrong?

Thanks,

Vishu

[former_member186338 · Accepted solution]

Sorry, but may be ...,C2:N2)?

Vadim

[Former Member · Accepted solution]

Yes Vadim it will work fine if i take range "C2:N2" but i required B2 also for another requirements ?

Thanks,

Vishu

[former_member186338 · Accepted solution]

Copy Range is working for the report data range only, not for row axis! If you start with B2 then the first data column will be formatted as B2. Hope it's clear.

Vadim

[Former Member · Accepted solution]

Thanks! I got your point.

My report ares starts from "O35" and used source range "K12:Z12" in Copy range

and used formula "=IF(J12<>"",J12,"")" on K12 Column still i can get vales on K what ever have listed on J column. and same thing used epmproperty functions on L and M column and some some how i am getting values.

Thanks,

Vishu

[Former Member · Accepted solution]

Thanks Vadim.

Actually i did insert the column before starting of reporting area (O35 - above screen shot) that why K column is getting values from J column.

Regards,

Vishu

[former_member186338 · Accepted solution]

Then close the discussion!

The rule for CopyRange is simple:

Let's assume that inside CopyRange you reference the range containing single row: K12:Z12

Then the first cell of this range (K12) will be copied in the left column of the data range (O) etc...

Vadim