This discussion is archived
2 Replies Latest reply: Oct 5, 2012 10:52 AM by Sumant RSS

Changing Header Text in Planning Sheet

Sumant Newbie
Currently Being Moderated
Hi,

As of now we see Dimension name/Attribute and Cube name above Measures as column header in planning sheet.

Like changing column Header for Measures as 'Measures' rather than cube name.
I see user guide has some pictures on page 71, which has header as 'Measures'

I couldn't find any way to just hard code the value of header displayed.

is it possible to change column header?

Thanks,
Sumant
  • 1. Re: Changing Header Text in Planning Sheet
    886918 Newbie
    Currently Being Moderated
    If you open an xml for planning sheet, you can add an attribute for RowAxisLayout as showDimensionName="false".
    Then you can hardcode any names to the dimension in the excel sheet.
  • 2. Re: Changing Header Text in Planning Sheet
    Sumant Newbie
    Currently Being Moderated
    Thanks,

    I found that in .xsd, It doesn't show the Dimension name , however it clears out the headers. Whatever I put in header cells from back end by modifying the xls,
        <xsd:complexType name="RowAxisLayout">
            <xsd:complexContent>
                <xsd:extension base="AxisLayout">
                    <xsd:attribute name="columnOffset" type="xsd:int" use="required" />
                    <xsd:attribute name="showDimensionName" type="xsd:boolean" use="optional" default="true" />
                </xsd:extension>
            </xsd:complexContent>
        </xsd:complexType>
    Regards,
    Sumant

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points