If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Combination chart Conditional palette Issue !!!!!!!

Started by PRIT AMRIT, 27 Oct 2010 10:22:28 PM

Previous topic - Next topic

PRIT AMRIT

Q-1. I have a combination chart.
   X-Axis shows the NPW Actual & GPW Actual.
   Y-axis shows NPW Budget & GPW Budget. For Budget the 'Line Type' i am using is 'Point to Point'
For the X-axis bars, I have applied the Conditional Palette like if Update_Flag=0 then change the bar color to RED. This is working fine. The issue is whenever it is changing the X-axis bar colors, it is also changing the Budget Line 'Point' colors, which I don't want be changed. Refer to the attached screenshot. The Points are marked in BLUE. I don't want the BLUE marked points to be changed.

Since the Budget and Actual referes to be same query, budget line also validating the Update_flag condition and changing the 'Points'. Is there a way to make the NPW Budget & GPW Budget Line colors as static. I mean should show the same color as other months.

Attached find the XML Specification also to have a better understanding.

Q-2. Is there any option to set the background Horizontal line to 4 in a Chart Report. Irrespective of the underlying DATA, Cognos should calculate the scale value and restrict the background horizontal line within 4 lines. Attached find the screenshot 'Question 2'.





----------------------------------------------------

REPORT XML Spec

<report xmlns="http://developer.cognos.com/schemas/report/5.0/" expressionLocale="en">
            <modelPath>/content/package[@name='eMeasure']/model[@name='model']</modelPath>
            <drillBehavior modelBasedDrillThru="true"/>
            <queries>
               <query name="China">
                  <source>
                     <model/>
                  </source>
                  <selection><dataItem name="branch" aggregate="none" rollupAggregate="none"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Branch]</expression></dataItem><dataItem name="Profit Center Name" aggregate="none" rollupAggregate="none"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Profit Center Name]</expression></dataItem><dataItem name="fiscal_quarter_name" aggregate="none" rollupAggregate="none"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Fiscal Quarter Name]</expression></dataItem><dataItem name="fiscal_quarter" aggregate="none" rollupAggregate="none"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Fiscal Quarter Name]</expression></dataItem><dataItem name="fiscal_month_name" aggregate="none" rollupAggregate="none"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Fiscal Month Name]</expression></dataItem><dataItem name="fiscal_month" aggregate="none" rollupAggregate="none"><expression>case [BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Fiscal Month Name]
when 'Dec' then '1'
when 'Jan' then '2'
when 'Feb' then '3'
when 'Mar' then '4'
when 'Apr' then '5'
when 'May' then '6'
when 'Jun' then '7'
when 'Jul' then '8'
when 'Aug' then '9'
when 'Sept' then '10'
when 'Oct' then '11'
when 'Nov' then '12'
end</expression></dataItem><dataItem name="qtd1_rmb_budget" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd1_budget_rmb]</expression></dataItem><dataItem name="qtd2_rmb_budget" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd2_budget_rmb]</expression></dataItem><dataItem name="qtd3_rmb_budget" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd3_budget_rmb]</expression></dataItem><dataItem name="qtd4_rmb_budget" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd4_budget_rmb]</expression></dataItem><dataItem name="Data Item1" aggregate="total"><expression>CASE
WHEN [fiscal_quarter]='1'
THEN [qtd1_rmb_budget]
WHEN [fiscal_quarter]='2'
THEN [qtd2_rmb_budget]
WHEN [fiscal_quarter]='3'
THEN [qtd3_rmb_budget]
WHEN [fiscal_quarter]='4'
THEN [qtd4_rmb_budget]
END</expression></dataItem><dataItem name="qtd_rmb_gpw" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd_gpw_rmb]</expression></dataItem><dataItem name="qtd_npw_rmb" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd_npw_rmb]</expression></dataItem><dataItem name="qtd1_npw_budget_rmb" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd1_npw_budget_rmb]</expression></dataItem><dataItem name="qtd2_npw_budget_rmb" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd2_npw_budget_rmb]</expression></dataItem><dataItem name="qtd3_npw_budget_rmb" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd3_npw_budget_rmb]</expression></dataItem><dataItem name="qtd4_npw_budget_rmb" aggregate="total"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[qtd4_npw_budget_rmb]</expression></dataItem><dataItem name="update_flag" aggregate="none" rollupAggregate="none"><expression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[update_flag]</expression></dataItem></selection>
               <detailFilters><detailFilter><filterExpression>[BUSINESS VIEW].[RPT_GPW_BUDGET_TVSHOW].[Fiscal Year]='2010'</filterExpression></detailFilter><detailFilter><filterExpression>[branch] in ('Beijing','Guangdong','Shanghai','Shenzhen')</filterExpression></detailFilter><detailFilter><filterExpression>[Profit Center Name]='TOTAL'</filterExpression></detailFilter></detailFilters><queryHints><localCache value="false"/></queryHints></query>
            </queries>
            <layouts>
               <layout>
                  <reportPages>
                     <page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
                        <pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
                           <contents>
                              
                           
                  <combinationChart showTooltips="true" maxHotspots="10000" refQuery="China" name="Combination Chart121">
                                                            <ordinalAxis>
                                                               <axisLine color="black"/>
                                                               <style>
                                                                  <defaultStyles>
                                                                     <defaultStyle refStyle="al"/>
                                                                  </defaultStyles>
                                                               </style>
                                                            </ordinalAxis>
                                                            <numericalAxisY1 min="0" scaleInterval="75000000">
                                                               <gridlines color="#cccccc"/>
                                                               <axisLine color="black"/>
                                                               <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="al"/>
                              </defaultStyles>
                           <dataFormat><numberFormat scale="-6"/></dataFormat></style></numericalAxisY1>
                                                            <combinationChartTypes>
                                                               <bar showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd_npw_rmb"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></bar>
                                                               <line dataPointSize="6" pointChartDataPointShape="diamond" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd1_npw_budget_rmb"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <line dataPointSize="6" pointChartDataPointShape="diamond" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd2_npw_budget_rmb"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <line dataPointSize="6" pointChartDataPointShape="diamond" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd3_npw_budget_rmb"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <line dataPointSize="6" pointChartDataPointShape="diamond" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd4_npw_budget_rmb"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <bar showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd_rmb_gpw"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></bar>
                                                               <line dataPointSize="6" pointChartDataPointShape="series" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd1_rmb_budget"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <line dataPointSize="6" pointChartDataPointShape="series" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd2_rmb_budget"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <line dataPointSize="6" pointChartDataPointShape="series" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd3_rmb_budget"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                               <line dataPointSize="6" pointChartDataPointShape="series" weight="2" showBorders="true"><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="qtd4_rmb_budget"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></line>
                                                            </combinationChartTypes>
                                                            <style><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles><CSS value="width:500px;height:584px"/></style><chartTitle refQuery="China"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles></style><chartContents><chartTextItem><dataSource><staticValue>FY2010 China Total GPW and NPW</staticValue></dataSource></chartTextItem></chartContents></chartTitle><chartPalette><chartColor value="rgb(132,0,132)"/><chartColor value="rgb(132,0,132)"/><chartColor value="rgb(132,0,132)"/><chartColor value="rgb(132,0,132)"/><chartColor value="rgb(132,0,132)"/><chartColor value="rgb(206,154,255)"/><chartColor value="rgb(206,154,255)"/><chartColor value="rgb(206,154,255)"/><chartColor value="rgb(206,154,255)"/><chartColor value="rgb(206,154,255)"/></chartPalette><commonClusters><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="fiscal_month_name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="fiscal_quarter"/><sortItem refDataItem="fiscal_month"/></sortList><propertyList><propertyItem refDataItem="update_flag"/></propertyList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></commonClusters><conditionalChartColors refVariable="ChinaUpdateFlag"><conditionalChartColor refVariableValue="1"><chartColor value="red"/></conditionalChartColor></conditionalChartColors></combinationChart></contents>
                        </pageBody>
                        <pageHeader>
                           <contents>
                              <block><style><defaultStyles><defaultStyle refStyle="ta"/></defaultStyles><CSS value="color:rgb(49,48,156);font-size:18pt;font-weight:bold"/></style>
                                 <contents>
                                    
                                 <table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents><textItem><style><defaultStyles><defaultStyle refStyle="tt"/></defaultStyles><CSS value="text-decoration:none"/></style>
                                       <dataSource>
                                          <staticValue>2010 China Total GPW and NPW - By Branch</staticValue>
                                       </dataSource>
                                    </textItem></contents><style><CSS value="text-align:center;font-family:Arial;font-size:18pt;font-weight:bold;color:rgb(49,48,156)"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>(Currency: RMB)</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents><style><CSS value="text-align:right;font-family:Arial;font-size:8pt;font-weight:normal;color:green"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
                              </block>
                           </contents>
                           <style>
                              <defaultStyles>
                                 <defaultStyle refStyle="ph"/>
                              </defaultStyles>
                              
                           </style>
                        </pageHeader>
                        
                     </page>
                  </reportPages>
               </layout>
            </layouts>
         <XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/></XMLAttributes><reportVariables><reportVariable type="boolean" name="ShanghaiUpdateFlag">
         <reportExpression>[Shanghai].[qtd_rmb_gpw]  IN (4884268.49578341)</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable><reportVariable type="boolean" name="GuangdongUpdateFlag">
         <reportExpression>[Guangdong].[update_flag]=0</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable><reportVariable type="boolean" name="BeijingUpdateFlag">
         <reportExpression>[Beijing].[update_flag]=0</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable><reportVariable type="boolean" name="ShenzhenUpdateFlag">
         <reportExpression>[Shenzhen].[update_flag]=0</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable><reportVariable type="boolean" name="ChinaUpdateFlag">
         <reportExpression>[China].[update_flag]=0</reportExpression>
         <variableValues>
            <variableValue value="1"/>
         </variableValues>
      </reportVariable></reportVariables></report>


---------------------------------------------------------------------

Unable to attach the screenshots or Zip files... Any idea?