Formatting options in EPM 10

[former_member244687]

Hi All,

      I need give page numbering and giving colour to hierarchies, I have a strange question here . what are generally done apart from these two formatting options, I need to give a demo to my customer.

thanks

Raj

[former_member210696]

Hi Raj,

Chapter 18.2 and Chapter 25 in the EPM user guide describes a lot about the various kinds of formating available and how to achieve that. Suggest you go through these and incorporate the ones which you want to demonstrate to the client. Link to the guide -

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

[former_member244687]

what is the difference between format in the sheet options and 'view format' , I need page number and hierarchy coloring first, can yo please suggest, thanks

[former_member210696]

Hi Raj,

In sheet options, these are just options available to users, and they are not related to format only, these are related to the sheet which you are working upon, i.e. your current report. And, the Formatting tab in Sheet options will only have few things (kind of behaviours) which you can change using these. For ex - Row Header Indentation - If you want all dim members to be indented same in your report, choose no indentation, all will be aligned same.

For hierarcy coloring, if you go to the Formatting Sheet in your report, there you can find Hierarchy Level Formatting, there you can format the cells in the desired color combination based on what you provide for a parent/child level member. Your report will build accordingly.

Hope it helps!!

[Former Member]

Hi,

The sheet options are for structural formatting (or options).

For doing the color based or text based formatting, you need to access the "view format" link. This will open an additional sheet.

Hope this helps.

[former_member244687]

thanks, I need two things, one is color to hierarchy member and most important page number. how do I do that, I did not find in documentation , one more thing should I hide the view page sheet after formatting

[Former Member]

Hi,

Hierarchy member formatting can be done. You just need to mention what kind of formatting you would like to apply to each level of the hierarchy.

Regarding page numbers, do you want kind of a water mark with the page number? If yes, then its a standard excel feature. There is nothing special in BPC for this.

Yes, it should be hidden from the user.

Hope this helps.

[former_member244687]

thanks Nilanjan, in it how do I give color to hierarchy ?

[Former Member]

Hi,

In the formatting options, there is a section for hierarchy formatting. In that you can format the different data cells at individual levels of the hierarchy. You can even have separate formatting for the heading at different hierarchy level.

Hope this helps.

[former_member244687]

HI, can you tell me where in this part I should take the color options

[Former Member]

Hi,

Select the third apply section for "formatting on specific level". Now, under the data section, you can select the cell and apply some coloring to that. You can apply different colors to different levels. You can even add / remove levels.

On top, you will be able to see 2 options - "structural hierarchy" and one more (I forgot the name).

Structural format takes the hierarchy levels based on the member sheet. The other option takes the levels based on the members displayed in the template.

Hope this helps.

[Former Member]

Hi Raj,

You can different types of formatting.

Formatting can be done to hierarchy levels.

You can lock a certain data cell(s).

You can do the banding. Every even and odd rows or columns will have separate colors.

You can do formatting based on the property value of the member.

It will be quite difficult to list down all the features.

[Former Member]

Thanks for your replies,

I need to insert a column in between the report, and i want the column in some formatting. But the report members in different format. I applied formatting for report members in formatting sheet, but what happens is after refresh the inserted column also changed to report member colour.

Kindly help me..

[Former Member]

Hi Kavi,

I would request you to raise a separate thread for your query.