tag:blogger.com,1999:blog-7002280773130180658.post7743628504087370998..comments2023-08-06T05:46:15.582-07:00Comments on Marc Experiencing Cognos BI: Welcome!Unknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7002280773130180658.post-91356784193360941722010-01-08T10:28:35.088-08:002010-01-08T10:28:35.088-08:00I need to create conditional palette for stacked b...I need to create conditional palette for stacked bar chart. The conditional palette should affect only one series. I defined conditional string variable: If ([Query3].[CH]>0 ) then ('Red') else ('Green'). Next I defined Conditional Palette to set palette colors to Red and Green. The issue I have is following: the color is applied to the entire bar. I need to get result where only [CH] part of bar will be Green or Red depended on condition and other series should be unchanged. It looks like that this operation can be done only on a single set of series. It ignores multiple series. Please let me know if you have solution for my issue. Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-87070330815599457262009-12-16T03:26:38.803-08:002009-12-16T03:26:38.803-08:00I would try to use an if..then..else construction ...I would try to use an if..then..else construction in the Data Item expression, however this may or may not work....<br /><br />Anyone else having a better suggestion?Marchttps://www.blogger.com/profile/05532687204341383992noreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-40587592907435329172009-12-16T03:23:57.882-08:002009-12-16T03:23:57.882-08:00This comment has been removed by the author.Marchttps://www.blogger.com/profile/05532687204341383992noreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-11281448855489692742009-12-15T20:07:26.852-08:002009-12-15T20:07:26.852-08:00Hi Marc,
Would you happen to know if there's ...Hi Marc,<br /><br />Would you happen to know if there's a way to set crosstab members based on parameters for dimensional data? For example, we have a Sales query subject with Region and Branch data items. We are able to determine the report user's level (Region Manager or Branch Manager) based on their UserName. If the user is a Region Manager, the crosstab member should be the set of branches for that region. If the user is a Branch Manager, the crosstab member should be the set of employess for that branch.<br /><br />Can this be done? Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-46795639942301284202008-02-19T23:23:00.000-08:002008-02-19T23:23:00.000-08:00Hi,I don't expect any other limitations than usual...Hi,<BR/><BR/>I don't expect any other limitations than usual. You should compare this usage of Cognos BI with stored procedures just like any other (web) application using stored procedures, which I think is quite good practice in that area.<BR/><BR/>Maybe you should consider any security risks though, as Cognos now needs to use a database user that must have extended rights to execute stored procedures, in addition to selecting data from tables.Marchttps://www.blogger.com/profile/05532687204341383992noreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-80694183527154043132008-02-19T18:08:00.000-08:002008-02-19T18:08:00.000-08:00Hi Marc, do you know of any limitations of using s...Hi Marc, do you know of any limitations of using stored procedure query subject? I am concerned about the performance when multiple users will access that query subject for their reporting. Any help is greatly appreciated! Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-65219625772377903342007-04-04T04:47:00.000-07:002007-04-04T04:47:00.000-07:00To set the selected value of a list prompt using t...To set the selected value of a list prompt using the incoming, passed parameter value you could do this:<BR/><BR/>1) create a filter in the prompt query using the parameter passed on by the calling report (this would reduce the selected prompt values to the parameter passed)<BR/>2) modify the JavaScript so that only this value is selected (i.e. the second list item):<BR/><BR/>< script type="text/javascript"><BR/>function init()<BR/>{<BR/> if<BR/> (document.formWarpRequest._oLstChoicesPeriode.options[2].selected == false)<BR/> {<BR/> document.formWarpRequest._oLstChoicesPeriode.options[2].selected = true;<BR/> listBoxPeriode.autoSubmit();<BR/> }<BR/>}<BR/></script><BR/>< body onLoad=init()>Marchttps://www.blogger.com/profile/05532687204341383992noreply@blogger.comtag:blogger.com,1999:blog-7002280773130180658.post-69438411273108330982007-04-03T19:57:00.000-07:002007-04-03T19:57:00.000-07:00Marc, Do you know how to set the selected value o...Marc, Do you know how to set the selected value of a list prompt using the in-coming, passed parameter value?Anonymousnoreply@blogger.com