Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Pivot view calculation going wrong
Answers
-
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=""A - Sample Sales"">
<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>
0