Skip to content

Instantly share code, notes, and snippets.

Embed
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
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.