Pivot view calculation going wrong - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pivot view calculation going wrong

Received Response
72
Views
11
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Not sure if I'm speaking chinese or some dead language but once more:

    a) If you let the DIMENSION do the splitting of the MEASURE then it will work. And not use any weird formulae.

    b) If you use FILTER - the function - you don't NEED any filters - filters as in analysis filters.

    tl;dr - this will work on any SA:

    <saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">

       <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;A - Sample Sales&quot;">

          <saw:columns>

             <saw:column xsi:type="saw:regularColumn" columnID="c4ba977d3126195f9">

                <saw:columnFormula>

                   <sawx:expr xsi:type="sawx:sqlExpression">"Time"."T05 Per Name Year"</sawx:expr></saw:columnFormula></saw:column>

             <saw:column xsi:type="saw:regularColumn" columnID="cca2abe630db82f67">

                <saw:columnFormula>

                   <sawx:expr xsi:type="sawx:sqlExpression">"Products"."P4  Brand"</sawx:expr></saw:columnFormula></saw:column>

             <saw:column xsi:type="saw:regularColumn" columnID="cac797b0cd4bd6ea0">

                <saw:columnFormula>

                   <sawx:expr xsi:type="sawx:sqlExpression">FILTER("Base Facts"."1- Revenue" using "Time"."T05 Per Name Year"=2014)</sawx:expr></saw:columnFormula>

                <saw:tableHeading>

                   <saw:caption fmt="text">

                      <saw:text>Base Facts</saw:text></saw:caption></saw:tableHeading>

                <saw:columnHeading>

                   <saw:caption fmt="text">

                      <saw:text>2014 Revenue</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns></saw:criteria>

       <saw:views currentView="0">

          <saw:view xsi:type="saw:compoundView" name="compoundView!1">

             <saw:cvTable>

                <saw:cvRow>

                   <saw:cvCell viewName="titleView!1"/></saw:cvRow>

                <saw:cvRow>

                   <saw:cvCell viewName="tableView!1"/></saw:cvRow></saw:cvTable></saw:view>

          <saw:view xsi:type="saw:titleView" name="titleView!1"/>

          <saw:view xsi:type="saw:tableView" name="tableView!1" scrollingEnabled="true">

             <saw:edges>

                <saw:edge axis="page" showColumnHeader="true"/>

                <saw:edge axis="section"/>

                <saw:edge axis="row" showColumnHeader="true">

                   <saw:edgeLayers>

                      <saw:edgeLayer type="column" columnID="c4ba977d3126195f9"/>

                      <saw:edgeLayer type="column" columnID="cca2abe630db82f67"/>

                      <saw:edgeLayer type="column" columnID="cac797b0cd4bd6ea0"/></saw:edgeLayers></saw:edge>

                <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views></saw:report>