No Singleton in CWA

[satay2hot]

Just a note - love CWA and think this is a good replacement for query studio.

However just noticed there is no singleton. The only to get away with this is to open up a report studio and create a singleton then go back to CWA. This is undesireable not every user has the report studio access.. Any way to get around with this?

Vince

[Lynn]

You can customize what is available through user profiles. I've never done it but my understanding is that the intention is to address exactly the type of thing you are describing.

http://www-01.ibm.com/support/knowledgecenter/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cra.10.2.2.doc/c_asg_userinterfaceprofiles.html?lang=en

As another alternative, it is possible to copy an XML fragment. The only thing they'd need to understand is which query the refQuery should refer to. If they are just starting with a new report and there is only one empty layout container on the screen, then the query for that will be Query1. The snippet below can be copy/pasted onto the page and it will be associated with that query. They can then drag anything into it and filter as needed.

Code Select Expand


<RSClipboardFragment version="2.0"><singleton name="Singleton1" refQuery="Query1">
<contents/>
</singleton></RSClipboardFragment>


If they already have an object and they now want a singleton, they'd need to drag in another container (list, crosstab, whatever) to create the second query, Query2. Then the above snippet would need to be edited to refer to Query2 instead of Query1 before copy and pasting.

A little crude but workable.