EPM Reports Borders

[Former Member]

Hello Everyone,

I have a query, Is there any option to excel Borders in the EPM reports which hve the dynamic formatting options aailable,

Actually I want to put boders in my report and I am using EMP formats also so when I refresh my report the border automatically get away.

I have unchecked the box "Clear Report format before applying dynamic formating" but still I am getting the issue.

Even I have a dropdowm list also in my report that also goes when ever i click on refresh.

Is there any way to retain the drop box and the borders along with the EPM formatting.

Thanks & Regards

Ronit Kumar

[Former Member]

Hi Vadim & Shrikant,

I have used EPMDimensionMembers function in sheet 2 to get all the members of entity dimention & then I have used a drop down in my main reporting sheet to select the epm context for entity(The shops) and i have checked member recognisation so whenever I select any shops through the drop down the results gets populated but as soon as i click refresh the sheet the drop dowm goes away.

Thanks & Regards

Ronit Kumar

[Shrikant_Jadhav]

Hi Ronit,

It's standard system behavior.

Still not clear about your requirement.

Explanation and screenshot will be helpful.

Shrikant 

[Former Member]

Hi Shrikant

Can i call in whatsapp and explain the scenario to you?

regards

Ronit kumar

[former_member186338]

Sorry but do you understand the word "screenshot"? If you want to get help you have to spend some time to explain the clear picture.

Vadim

[Former Member]

provide screen shots.

make sure the drop down is not inside your rows and column axis.

Andy

[Shrikant_Jadhav]

Hi Ronit,

Apply border to cell formatting trough formatting sheet.

Even I have a dropdowm list also in my report that also goes when ever i click on refresh.

Can you explain what exactly the report structure ?

Shrikant 

[former_member186338]

Agree with Shrikant - questions has to be less theoretical and the detailed explanation with screenshots has to be attached!

Vadim