If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to hide list or charts or ...

Started by marmas, 14 Oct 2013 05:20:42 AM

Previous topic - Next topic

marmas

Hi all,

I've read at IBM web that if you delete the name property of a data container (such as a list, crosstab or a chart), that container it is not available at Business Insight.

How ever, every time I try to delete in report studio the name property of one of these elements I got an error massage saying that the object needs an unique name.

Any idea why is this happening? I'm using cognos BI v10.1.1.

(excuse me for my terrible English)  :-[

bdbits

As far as I know, you do need a name for all objects. So I am not sure where you saw that you can delete it.

What are you trying to accomplish? I think there is likely a better way than this approach.

marmas

Hello,

I cant paste here the link I'm viewing because it is in spanish, but I've found this one, that it is for version  v.10.1.0 and has the same content:
http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_cr_rptstd.10.1.0.doc%2Fug_cr_rptstd_id3025recomm_bus_insight_dashboards.html

What I'm trying to do is that, most of my reports contains one ore more lists just for drill to other reports, but they do not contain usufull facts for users. I would like to find the way to avoid these objects from being listed in Business Insight tree-objects.

bdbits

You should look into render variables.

Assume you have a report with a list. Ensure that the list is the selected item in Report Studio, then locate the Render Variable property. Click the ellipsis, and pick <new boolean variable> from the dropdown.  Name the variable ShowList. Now you need an expression that evaluates to yes/true or no/false. For the moment, just enter the expression 1=0 which will always evaluate to no/false. Click OK. You'll see a single "Render for" value "Yes" with a checked box. This says that you want the control (list) to render when the expression evaluates to yes/true, which because we entered a false expression it will never do. Just click OK, and observe that "ShowList" is now set as the Render Variable property. Run your report, and you should find that the list is not visible. Return to Report Studio, choose menu View > Variables and double-click ShowList. Change the 1=0 to 1=1 so it will always evaluate to yes/true and click OK and run the report again. The list will now be visible.

So the crux for you then will be the expression - how will you determine whether or not to show the list. One option would be to create a dummy prompt variable, which you could then preset in the report properties.

Hopefully this at least gets you pointed in the general direction of a solution.