2 Replies Latest reply: Oct 5, 2012 12:52 PM by Sumant RSS

    Changing Header Text in Planning Sheet

    Sumant
      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
          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
            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