Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
Expand all | Collapse all

Adding Line Number to Crosstab using Planning Analytics Data

  • 1.  Adding Line Number to Crosstab using Planning Analytics Data

    Posted 09/23/19 03:44 PM
    Looking for some guidance on how to add a line number to a Crosstab report that is sourcing data from Planning Analytics. I have Googled this quite a bit and tried all of the suggestions, but none of them seem to work. What's the trick?

    #CognosAnalyticswithWatson


  • 2.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 09/27/19 01:26 PM

    @Ryan Clapp Try the following:

    1. From the toolbox - drag over a "Crosstab space (with Fact cells)" to the row edge of the crosstab.
    2. Unlock the report
    3. From the toolbox - drag over the object "Row number" and place it inside the Crosstab space added in Step1.

    Let me know if this works for you.



    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/01/19 02:51 PM
    Thanks, but that does not seem to work. The row number appears inside a table, which is 1 row and therefore only shows #1


    ------------------------------
    Ryan Clapp
    ------------------------------



  • 4.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/03/19 08:57 AM
    Edited by System Admin 01/20/23 04:11 PM
    @Ryan Clapp​ The solution provided will work if the row number is nested on the inner row edge. Let me see test and see if I can get a solution for the outer row edge.

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 5.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/03/19 09:33 AM

    @Ryan Clapp I've attached a sample report spec and output showing Row Numbers on the Crosstab. Basically, you will need to unlock the report and add the RowNumber item to the left of each row on the crosstab row edge​​.

    Let me know if this is what you are looking for.



    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Attachment(s)

    txt
    IBMCrosstabRowNumber.txt   6 KB 1 version


  • 6.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/07/19 02:28 PM

    I tired that and it give me an error:

     

    With the report locked I get this error:

     



    ------Original Message------

    @Ryan Clapp I've attached a sample report spec and output showing Row Numbers on the Crosstab. Basically, you will need to unlock the report and add the RowNumber item to the left of each row on the crosstab row edge​​.

    Let me know if this is what you are looking for.



    ------------------------------
    DENNY NAREZNY
    ------------------------------

    #CognosAnalyticswithWatson


  • 7.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/09/19 06:41 PM
    Ryan, please make sure that you unlock your report before you start dragging Row Number from the toolbar.

    ------------------------------
    Cognos Guru
    ------------------------------



  • 8.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/09/19 07:01 PM
    It is unlocked as I mentioned in the previous email. Here is a recording:


    ------------------------------
    Ryan Clapp
    ------------------------------



  • 9.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/10/19 07:48 AM
    @Ryan Clapp If possible could you attach a copy of your report spec? or you can send it to me via email. denny.narezny@ca.ibm.com

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 10.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/10/19 05:03 PM
    <report xmlns="http://developer.cognos.com/schemas/report/15.0/" expressionLocale="en-us" useStyleVersion="11.4"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/14.0/" to "http://developer.cognos.com/schemas/report/15.0/" at 2018-9-28. 8:49:37--><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/13.3/" to "http://developer.cognos.com/schemas/report/14.0/" at 2017-1-26. 15:28:50-->
    				
    				<drillBehavior/>
    				
    				<layouts>
    					<layout>
    						<reportPages>
    							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
    								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
    									<contents>
    										
    									<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="width:100%;border-spacing:0;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><reportExpression>'Year:' + ParamDisplayValue('pYear') + ', Product:' + ParamDisplayValue('pProduct') + ', Secenario:' +  ParamDisplayValue('pScenario')</reportExpression></dataSource><style><CSS value="font-weight:normal;font-style:italic;text-decoration:underline"/></style></textItem></contents><style><CSS value="width:25%;height:47px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents><crosstab horizontalPagination="true" name="Crosstab1" refQuery="Report">
    			
    			
    			
    			<noDataHandler>
    				<contents>
    					<block>
    						<contents>
    							<textItem>
    								<dataSource>
    									<staticValue>No Data Available</staticValue>
    								</dataSource>
    								<style>
    									<CSS value="padding:10px 18px;"/>
    								</style>
    							</textItem>
    						</contents>
    					</block>
    				</contents>
    			</noDataHandler>
    			<style>
    				<CSS value="border-collapse:collapse"/>
    				<defaultStyles>
    					<defaultStyle refStyle="xt"/>
    				</defaultStyles>
    			</style>
    		<defaultMeasure refDataItem="Amount"/><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e2" refDataItem="Set - Account Summary MF"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e3" refDataItem="Revenue"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;border-top:1.5pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e1" refDataItem="COGS"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:normal;border-top:1pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e4" refDataItem="Total Expense Incl SBC and OIE"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:normal;border-top:1pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e6" refDataItem="Total OpEx Assignment"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:normal;border-top:1pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e7" refDataItem="Total OpEx"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;border-top:1.5pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e8" refDataItem="Income Taxes"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:normal;border-top:0.5pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e9" refDataItem="Operating Income"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles><CSS value="font-weight:bold;border-top:1.5pt solid black"/></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember edgeLocation="e5" refDataItem="All Periods + Full Year"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Month"/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabSuppress/><crosstabIntersections><crosstabIntersection column="e5" row="e3"><style><CSS value="border-top:1.5pt solid black"/></style></crosstabIntersection><crosstabIntersection column="e5" row="e7"><style><CSS value="border-top:1.5pt solid black"/></style></crosstabIntersection><crosstabIntersection column="e5" row="e9"><style><CSS value="border-top:1.5pt solid black"/></style></crosstabIntersection></crosstabIntersections><crosstabRowNodeStyle><style><CSS value="width:250px"/></style></crosstabRowNodeStyle></crosstab></contents><style><CSS value="height:100%;width:85%;text-align:left;vertical-align:top"/><defaultStyles><defaultStyle refStyle="ContentDataContainerBottomRowLeftTableCell"/></defaultStyles></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="2"><contents/><style><CSS value="text-align:center;vertical-align:top;width:85%"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
    								</pageBody>
    								
    								<pageFooter>
    									<contents>
    										<table>
    											<tableRows>
    												<tableRow>
    													<tableCells>
    														<tableCell>
    															<contents>
    																<date>
    																	<style>
    																		<dataFormat>
    																			<dateFormat/>
    																		</dataFormat>
    																	</style>
    																</date>
    															</contents>
    															<style>
    																<CSS value="width:25%;text-align:left;vertical-align:top"/>
    															<defaultStyles><defaultStyle refStyle="FooterDateTableCell"/></defaultStyles></style>
    														</tableCell>
    														<tableCell>
    															<contents>
    																<pageNumber/>
    															</contents>
    															<style>
    																<CSS value="width:50%;text-align:center;vertical-align:top"/>
    															<defaultStyles><defaultStyle refStyle="FooterPageNumberTableCell"/></defaultStyles></style>
    														</tableCell>
    														<tableCell>
    															<contents>
    																<time>
    																	<style>
    																		<dataFormat>
    																			<timeFormat/>
    																		</dataFormat>
    																	</style>
    																</time>
    															</contents>
    															<style>
    																<CSS value="width:25%;text-align:right;vertical-align:top"/>
    															<defaultStyles><defaultStyle refStyle="FooterTimeTableCell"/></defaultStyles></style>
    														</tableCell>
    													</tableCells>
    												</tableRow>
    											</tableRows>
    											<style>
    												<defaultStyles>
    													<defaultStyle refStyle="tb"/>
    												</defaultStyles>
    												<CSS value="width:100%;border-collapse:collapse;border-spacing:0px"/>
    											</style>
    										</table>
    									</contents>
    									<style>
    										
    										<CSS value="padding:10px"/>
    									<defaultStyles><defaultStyle refStyle="FooterPageFooter"/></defaultStyles></style>
    								</pageFooter>
    							<pageHeader><contents><block>
    			<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><image>
    			<dataSource>
    				<staticValue>https://a0.static.com/libra-css/images/logos/_logo_smile_1200x630.png</staticValue>
    			</dataSource>
    		<style><CSS value="width:150px"/></style></image></contents><style><CSS value="width:5%"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue> Service Finance Product P&amp;L</staticValue></dataSource><style><CSS value="font-size:20pt"/></style></textItem></contents><style><CSS value="text-align:left;vertical-align:middle;padding-left:100px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
    		<style><defaultStyles><defaultStyle refStyle="HeaderReportTitleTableCell"/></defaultStyles><CSS value="text-align:center"/></style></block></contents><style><defaultStyles><defaultStyle refStyle="ph"/></defaultStyles></style></pageHeader></page>
    						</reportPages>
    					<promptPages><page name="Prompt page1">
    			<pageHeader>
    				<contents>
    					<block>
    						<contents>
    							<textItem>
    								<dataSource>
    									<staticValue>Product P&amp;L Prompts</staticValue>
    								</dataSource>
    								<style>
    									<defaultStyles>
    										<defaultStyle refStyle="tt"/>
    									</defaultStyles>
    								</style>
    							</textItem>
    						</contents>
    						<style>
    							<defaultStyles>
    								<defaultStyle refStyle="ta"/>
    							</defaultStyles>
    						<CSS value="text-align:left"/></style>
    					</block>
    				</contents>
    				<style>
    					<defaultStyles>
    						<defaultStyle refStyle="hp"/>
    					</defaultStyles>
    				</style>
    			</pageHeader>
    			<pageBody>
    				<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="width:10%"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Selct a reporting year:</staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><selectValue parameter="pYear" refQuery="Prompts"><useItem refDataItem="Year - L0"><displayItem refDataItem="Year - L0"/></useItem></selectValue></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Select a product:</staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><selectWithSearch parameter="pProduct" refQuery="Prompts"><useItem refDataItem="Product"><displayItem refDataItem="Product"/></useItem></selectWithSearch></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Select a scenario:</staticValue></dataSource></textItem></contents><style><CSS value="width:10%"/></style></tableCell><tableCell><contents><selectValue parameter="pScenario" refQuery="Prompts"><useItem refDataItem="Scenario - L0"><displayItem refDataItem="Scenario - L0"/></useItem></selectValue></contents></tableCell></tableCells></tableRow></tableRows></table></contents>
    				<style>
    					<defaultStyles>
    						<defaultStyle refStyle="py"/>
    					</defaultStyles>
    				</style>
    			</pageBody>
    			<pageFooter>
    				<contents>
    					<promptButton type="cancel">
    						<contents/>
    						<style>
    							<defaultStyles>
    								<defaultStyle refStyle="bp"/>
    							</defaultStyles>
    						</style>
    					</promptButton>
    					<promptButton type="back">
    						<contents/>
    						<style>
    							<defaultStyles>
    								<defaultStyle refStyle="bp"/>
    							</defaultStyles>
    						</style>
    					</promptButton>
    					<promptButton type="next">
    						<contents/>
    						<style>
    							<defaultStyles>
    								<defaultStyle refStyle="bp"/>
    							</defaultStyles>
    						</style>
    					</promptButton>
    					<promptButton type="finish">
    						<contents/>
    						<style>
    							<defaultStyles>
    								<defaultStyle refStyle="bp"/>
    							</defaultStyles>
    						</style>
    					</promptButton>
    				</contents>
    				<style>
    					<defaultStyles>
    						<defaultStyle refStyle="fp"/>
    					</defaultStyles>
    				</style>
    			</pageFooter>
    			<style>
    				<defaultStyles>
    					<defaultStyle refStyle="pp"/>
    				</defaultStyles>
    			</style>
    		</page></promptPages></layout>
    				</layouts>
    			<XMLAttributes><XMLAttribute output="no" name="RS_CreateExtendedDataItems" value="true"/><XMLAttribute output="no" name="listSeparator" value=","/><XMLAttribute output="no" name="decimalSeparator" value="."/></XMLAttributes><queries><query name="Report"><source><model/></source><selection><dataItemMeasure name="Amount"><dmMember><MUN>[Management Financials Detail].[Management Financials Detail_m].[Amount (MM)].[Amount]</MUN><itemCaption>Amount</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Management Financials Detail_m]</DUN><itemCaption>Management Financials Detail_m</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="9"/></XMLAttributes></dataItemMeasure><dataItemSet name="Set - Account Summary MF"><dmMembers><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Revenue^Amortized Revenue]</MUN><itemCaption>Amortized Revenue</itemCaption></dmMember><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Revenue^Software Revenue]</MUN><itemCaption>Software Revenue</itemCaption></dmMember><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Revenue^Usage Revenue]</MUN><itemCaption>Usage Revenue</itemCaption></dmMember><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Revenue^Other Revenue]</MUN><itemCaption>Other Revenue</itemCaption></dmMember><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Credits, Refunds, &amp; Forgives]</MUN><itemCaption>Credits, Refunds, &amp; Forgives</itemCaption></dmMember><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Revenue^Revenue Hedge]</MUN><itemCaption>Revenue Hedge</itemCaption></dmMember></dmMembers><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemSet><dataItemNamedSet name="All Periods + Full Year1"><NSUN>[Management Financials Detail].[Period].[Period].[All Periods + Full Year]</NSUN><dmDimension><DUN>[Management Financials Detail].[Period]</DUN><itemCaption>Period</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Period].[Period]</HUN><itemCaption>Period</itemCaption></dmHierarchy></dataItemNamedSet><dataItemMember name="Revenue"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Revenue]</MUN><itemCaption>Revenue</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItemNamedSet name="All Periods + Full Year"><NSUN>[Management Financials Detail].[Period].[Period].[All Periods + Full Year]</NSUN><dmDimension><DUN>[Management Financials Detail].[Period]</DUN><itemCaption>Period</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Period].[Period]</HUN><itemCaption>Period</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemNamedSet><dataItemHierarchySet name="Product"><dmDimension><DUN>[Management Financials Detail].[Product]</DUN><itemCaption>Product</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Product].[Product]</HUN><itemCaption>Product</itemCaption></dmHierarchy></dataItemHierarchySet><dataItemHierarchySet name="Scenario"><dmDimension><DUN>[Management Financials Detail].[Scenario]</DUN><itemCaption>Scenario</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Scenario].[Scenario]</HUN><itemCaption>Scenario</itemCaption></dmHierarchy></dataItemHierarchySet><dataItemHierarchySet name="Year"><dmDimension><DUN>[Management Financials Detail].[Year]</DUN><itemCaption>Year</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Year].[Year]</HUN><itemCaption>Year</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemHierarchySet><dataItemMember name="COGS"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[COGS]</MUN><itemCaption>COGS</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItemMember name="Total Expense Incl SBC and OIE"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Total Expense Incl SBC and OIE]</MUN><itemCaption>Total Expense Incl SBC and OIE</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItemMember name="Total OpEx Assignment"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Total OpEx Assignment]</MUN><itemCaption>Total OpEx Assignment</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItemMember name="Total OpEx"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Total OpEx]</MUN><itemCaption>Total OpEx</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItemMember name="Income Taxes"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Income Taxes]</MUN><itemCaption>Income Taxes</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItemMember name="Operating Income"><dmMember><MUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]-&gt;:[TMR].[Account Summary MF].[Account Summary MF].[Operating Income]</MUN><itemCaption>Operating Income</itemCaption></dmMember><dmDimension><DUN>[Management Financials Detail].[Account Summary MF]</DUN><itemCaption>Account Summary MF</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Account Summary MF].[Account Summary MF]</HUN><itemCaption>Account Summary MF</itemCaption></dmHierarchy><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/></XMLAttributes></dataItemMember><dataItem aggregate="none" rollupAggregate="none" name="Month"><expression>[Management Financials Detail].[Period].[Period].[Month]</expression><XMLAttributes><XMLAttribute output="no" name="RS_dataType" value="3"/><XMLAttribute output="no" name="RS_dataUsage" value="0"/><XMLAttribute output="no" name="RS_HUN" value="[Management Financials Detail].[Period].[Period]"/></XMLAttributes></dataItem></selection><slicer><slicerMemberSet>set([Year]-&gt;?pYear?)</slicerMemberSet><slicerMemberSet>set([Product]-&gt;?pProduct?)</slicerMemberSet><slicerMemberSet>set([Scenario]-&gt;?pScenario?)</slicerMemberSet></slicer></query><query name="Prompts">
    			<source>
    				<model/>
    			</source>
    			<selection><dataItemNamedSet name="Scenario - L0"><NSUN>[Management Financials Detail].[Scenario].[Scenario].[Scenario - L0]</NSUN><dmDimension><DUN>[Management Financials Detail].[Scenario]</DUN><itemCaption>Scenario</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Scenario].[Scenario]</HUN><itemCaption>Scenario</itemCaption></dmHierarchy></dataItemNamedSet><dataItemNamedSet name="Year - L0"><NSUN>[Management Financials Detail].[Year].[Year].[Year - L0]</NSUN><dmDimension><DUN>[Management Financials Detail].[Year]</DUN><itemCaption>Year</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Year].[Year]</HUN><itemCaption>Year</itemCaption></dmHierarchy></dataItemNamedSet><dataItemHierarchySet name="Product"><dmDimension><DUN>[Management Financials Detail].[Product]</DUN><itemCaption>Product</itemCaption></dmDimension><dmHierarchy><HUN>[Management Financials Detail].[Product].[Product]</HUN><itemCaption>Product</itemCaption></dmHierarchy></dataItemHierarchySet></selection>
    		</query></queries><modelPath>/content/folder[@name='Service Finance']/folder[@name='TM1 Packages']/package[@name='Management Financials']/model[last()]</modelPath><reportName>Sample Revenue</reportName><classStyles><classStyle name="GuidedLayoutPadding"><CSS value="padding-right:10px"/></classStyle><classStyle name="GuidedLayoutMargin"><CSS value="margin-bottom:10px"/></classStyle></classStyles></report>

    Thanks for the continued help!

    ------------------------------
    Ryan Clapp
    ------------------------------



  • 11.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/10/19 06:08 PM
      |   view attached
    @Ryan Clapp - Attached is your report spec with rownumber added. Let me know if it works for you.​

    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Attachment(s)

    txt
    RowNumberSpecIBM.txt   23 KB 1 version


  • 12.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/10/19 06:38 PM
    That works! What was the trick? I coudn't get the row number to fit into that spot lol.

    ------------------------------
    Ryan Clapp
    ------------------------------



  • 13.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/11/19 04:09 PM
    No trick, not sure why it did not work for you. But glad it is working for you now.

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 14.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/14/19 12:07 PM
    Tested a bit more. Dragging and dropping won't work no matter what I tried. If I unlock, click on the row, then double click the row number in the toolbox it worked.


    ------Original Message------

    No trick, not sure why it did not work for you. But glad it is working for you now.

    ------------------------------
    DENNY NAREZNY
    ------------------------------

    #CognosAnalyticswithWatson


  • 15.  RE: Adding Line Number to Crosstab using Planning Analytics Data

    Posted 10/15/19 08:18 AM
    Ryan,

     Could you post XML spec of the report? Also please include Cognos version number. I'll do my best to help you.


    ------------------------------
    Cognos Guru
    ------------------------------