Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
<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;CHANGE ME TO ONE OF YOUR SUBJECT AREAS&quot;" withinHierarchy="true">
<saw:columns>
<saw:column xsi:type="saw:regularColumn" columnID="c3852bb67e9ce862f">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">VALUEOF(NQ_SESSION.USER)</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="suppress" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>USER</saw:text></saw:caption>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c2ba217e0c7e5e614">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">VALUEOF(NQ_SESSION.DISPLAYNAME)</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>DISPLAYNAME</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c1143748cb23fd299">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">VALUEOF(NQ_SESSION.USERLOCALE)</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>USERLOCALE</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c4ad39993c9821c65">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">VALUEOF(NQ_SESSION.LOGLEVEL)</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>LOGLEVEL</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cf41fcea6efa31db9">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">VALUEOF(NQ_SESSION.USERGUID)</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="suppress" fontSize="10" wrapText="true"/></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>USERGUID</saw:text></saw:caption>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="cf3150aaf7f2c9550">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">VALUEOF(NQ_SESSION.ROLES)</sawx:expr></saw:columnFormula>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>ROLES</saw:text></saw:caption></saw:columnHeading></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c8bf20309ff326322">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">'&lt;div style="height:240px; width:400px;overflow:auto;"&gt;'||REPLACE(VALUEOF(NQ_SESSION.PERMISSIONS),';',' ')||'&lt;/div&gt;'</sawx:expr></saw:columnFormula>
<saw:displayFormat>
<saw:formatSpec suppress="suppress" wrapText="true">
<saw:dataFormat textFormat="html" xsi:type="saw:text"/></saw:formatSpec></saw:displayFormat>
<saw:tableHeading>
<saw:caption fmt="text">
<saw:text>NQ_SESSION</saw:text></saw:caption>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:tableHeading>
<saw:columnHeading>
<saw:caption fmt="text">
<saw:text>PERMISSIONS</saw:text></saw:caption>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></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" colSpan="3"/></saw:cvRow>
<saw:cvRow>
<saw:cvCell viewName="htmlview!1"/>
<saw:cvCell viewName="htmlview!2" colSpan="2"/></saw:cvRow>
<saw:cvRow>
<saw:cvCell viewName="pivotTableView!2">
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:cvCell>
<saw:cvCell viewName="narrativeView!1">
<saw:displayFormat>
<saw:formatSpec hAlign="left"/></saw:displayFormat></saw:cvCell>
<saw:cvCell viewName="narrativeView!2">
<saw:displayFormat>
<saw:formatSpec hAlign="left"/></saw:displayFormat></saw:cvCell></saw:cvRow></saw:cvTable></saw:view>
<saw:view xsi:type="saw:pivotTableView" name="pivotTableView!2">
<saw:viewCaption>
<saw:caption>
<saw:text>System Session Variables</saw:text></saw:caption></saw:viewCaption>
<saw:edges>
<saw:edge axis="page" showColumnHeader="true"/>
<saw:edge axis="section"/>
<saw:edge axis="row" showColumnHeader="false">
<saw:edgeLayers>
<saw:edgeLayer type="measure"/></saw:edgeLayers></saw:edge>
<saw:edge axis="column"/></saw:edges>
<saw:measuresList>
<saw:measure columnID="c3852bb67e9ce862f" aggRule="last"/>
<saw:measure columnID="c2ba217e0c7e5e614" aggRule="last"/>
<saw:measure columnID="c1143748cb23fd299" aggRule="last"/>
<saw:measure columnID="c2e3dfd8a10885129" aggRule="last"/>
<saw:measure columnID="c4ad39993c9821c65" aggRule="last">
<saw:dataBodyFormat>
<saw:displayFormat>
<saw:formatSpec hAlign="left" wrapText="true"/></saw:displayFormat></saw:dataBodyFormat></saw:measure>
<saw:measure columnID="cf41fcea6efa31db9" aggRule="last"/>
<saw:measure columnID="cf3150aaf7f2c9550" aggRule="last"/>
<saw:measure columnID="c8bf20309ff326322" aggRule="last"/></saw:measuresList></saw:view>
<saw:view xsi:type="saw:titleView" name="titleView!1" includeName="false" startedDisplay="none">
<saw:title>
<saw:caption fmt="text">
<saw:text>System Variables</saw:text></saw:caption></saw:title></saw:view>
<saw:view xsi:type="saw:htmlview" name="htmlview!1">
<saw:viewCaption>
<saw:caption>
<saw:text>System Session Variables Header</saw:text></saw:caption></saw:viewCaption>
<saw:staticText>
<saw:caption fmt="html">
<saw:text>[b]System &lt;font color=#145c9e&gt;Session&lt;/font&gt; Variables[/b]</saw:text></saw:caption></saw:staticText></saw:view>
<saw:view xsi:type="saw:htmlview" name="htmlview!2">
<saw:viewCaption>
<saw:caption>
<saw:text>System Presentation Variables Header</saw:text></saw:caption></saw:viewCaption>
<saw:staticText>
<saw:caption fmt="html">
<saw:text>[b]System &lt;font color=#145c9e&gt;Presentation&lt;/font&gt; Variables[/b]</saw:text></saw:caption></saw:staticText>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:view>
<saw:view xsi:type="saw:narrativeView" name="narrativeView!1">
<saw:narrative>
<saw:caption fmt="html">
<saw:text>[br/]
[b]dashboard.currentPage:[/b] @{dashboard.currentPage}[br/]
[b]dashboard.author:[/b] @{dashboard.author}[br/]
[b]dashboard.caption:[/b] @{dashboard.caption}[br/]
[b]dashboard.description:[/b] @{dashboard.description}[br/]
[b]dashboard.location:[/b] @{dashboard.location}[br/]
[b]dashboard.name:[/b] @{dashboard.name}[br/]
[b]dashboard.path:[/b] @{dashboard.path}[br/]
[b]dashboard.xml:[/b] @{dashboard.xml}[br/]
[b]report.name:[/b] @{report.name}[br/]
[b]report.path:[/b] @{report.path}[br/]
[b]session.currentUser:[/b] @{session.currentUser}[br/]
[b]session.language:[/b] @{session.language}[br/]
[b]session.lastAccessTime:[/b] @{session.lastAccessTime}[br/]
[b]session.locale:[/b] @{session.locale}[br/]
[b]session.loginTime:[/b] @{session.loginTime}[br/]
[b]session.logoutTime:[/b] @{session.logoutTime}[br/]
[b]session.rtl:[/b] @{session.rtl}[br/]
[b]session.timeZone:[/b] @{session.timeZone}[br/]
[b]session.timeZone.id:[/b] @{session.timeZone.id}[br/]
[b]session.timeZone.name:[/b] @{session.timeZone.name}[br/]
[b]session.timeZone.value:[/b] @{session.timeZone.value}[br/]
[b]system.currentTime:[/b] @{system.currentTime}[br/]
[b]system.productVersion:[/b] @{system.productVersion}[br/]
[b]user.displayName:[/b] @{user.displayName}[br/]
[b]user.homeDirectory:[/b] @{user.homeDirectory}[br/]
[b]user.id:[/b] @{user.id}[br/]</saw:text></saw:caption></saw:narrative>
<saw:prefix>
<saw:caption fmt="html">
<saw:text>[b]&lt;font size=2&gt;General&lt;/font&gt;[/b][br/]</saw:text></saw:caption></saw:prefix>
<saw:displayFormat>
<saw:formatSpec/></saw:displayFormat></saw:view>
<saw:view xsi:type="saw:narrativeView" name="narrativeView!2">
<saw:prefix>
<saw:caption fmt="html">
<saw:text>[b]&lt;font size=2&gt;Currency&lt;/font&gt;[/b][br/]</saw:text></saw:caption></saw:prefix>
<saw:narrative>
<saw:caption fmt="html">
<saw:text>[br/]
[b]analysis.report.currency.name:[/b] @{analysis.report.currency.name} [br/]
[b]analysis.report.currency.symbol:[/b] @{analysis.report.currency.symbol} [br/]
[b]analysis.report.currency.userPreference:[/b] @{analysis.report.currency.userPreference} [br/]
[b]dashboard.currentPage.currency.name:[/b] @{dashboard.currentPage.currency.name} [br/]
[b]dashboard.currentPage.currency.userPreference:[/b] @{dashboard.currentPage.currency.userPreference} [br/]
[b]dashboard.currentPage.currency.symbol:[/b] @{dashboard.currentPage.currency.symbol} [br/]
[b]dashboard.currentPage.currency.symbol.name:[/b] @{dashboard.currentPage.currency.symbol.name} [br/]
[b]dashboard.currentPage.currency.symbol.path:[/b] @{dashboard.currentPage.currency.symbol.path} [br/]
[b]dashboard.currency.name:[/b] @{dashboard.currency.name} [br/]
[b]dashboard.currency.symbol:[/b] @{dashboard.currency.symbol} [br/]
[b]dashboard.currency.userPreference:[/b] @{dashboard.currency.userPreference} [br/]
[b]session.currency.name:[/b] @{session.currency.name} [br/]
[b]session.currency.symbol:[/b] @{session.currency.symbol} [br/]
[b]session.currency.userPreference:[/b] @{session.currency.userPreference} [br/]</saw:text></saw:caption></saw:narrative></saw:view></saw:views>
<saw:prompts scope="report" subjectArea="&quot;CHANGE ME TO ONE OF YOUR SUBJECT AREAS&quot;"/></saw:report>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment