COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: charon on 27 Feb 2012 08:35:48 AM

Title: Filter Value in Report Header in Business Insight Advanced
Post by: charon on 27 Feb 2012 08:35:48 AM
Hi everyone,

im wondering, is there a way to display the (chosen prompt) filter value in the header of a report for relational data sources?
For DMR or dim. data sources, you can easily use a context filter, and the filtered value is displayed in the header.

How can i achieve this in BIA for rel. data ? display paramname or sth like that? Or is there a tricky way?

There is no time pressure, just wondering :)
any ideas welcome, cheerz
:P
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: Grim on 28 Feb 2012 08:54:33 AM
I should expect the following to still work. Have you tried it?

ParamDisplay("ParamName")
or
ParamDisplayValue("ParamName")
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: charon on 28 Feb 2012 10:45:56 AM
Hi Grim,

ty for replying. Ive tried this indeed, i mean of course i have the param name. But i have no idea how to enter this syntax? in BIA!
i mean, in report studio i would use layout calc. for example.
inserting a text item in bia wont do it for me as far as i experienced :(

Or do you have any futher idea how to use paramdisplay in bia?

if not, nvmd not that important, im just curious   ;D
have a nice evening, cheerz :P
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: MMcBride on 28 Feb 2012 11:39:43 AM
Wow, yet another reason to dislike BIA   8)

So in report Studio you can just drop a Text Item in the header and put the following
if (ParamDisplayValue('Productpr') is missing) then ('All Products') else (ParamDisplayValue('Productpr'))

Report Studio then knows you want to use Source Type "Report Expression" - you don't even have to think about it.
So I tried the same with BIA and it didn't work, and there was no way for me to modify an existing Text item to change the Text Source to a Report Expression...

However... I could create it in Report Studio and then Open it in BIA and it continues to work perfectly fine, you just can't modify it...

My dislike for BIA is growing every time I use it :)
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: Grim on 29 Feb 2012 07:05:27 AM
Quote from: MMcBride on 28 Feb 2012 11:39:43 AM
Wow, yet another reason to dislike BIA   8)

So in report Studio you can just drop a Text Item in the header and put the following
if (ParamDisplayValue('Productpr') is missing) then ('All Products') else (ParamDisplayValue('Productpr'))

Report Studio then knows you want to use Source Type "Report Expression" - you don't even have to think about it.
So I tried the same with BIA and it didn't work, and there was no way for me to modify an existing Text item to change the Text Source to a Report Expression...

However... I could create it in Report Studio and then Open it in BIA and it continues to work perfectly fine, you just can't modify it...

My dislike for BIA is growing every time I use it :)

And BIA is what is supposed to replace RS....hrrmmpph.  >:(
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: charon on 29 Feb 2012 07:43:39 AM
not RS...AS and QS ;)

Or am i misinformed (again)  ;D
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: Grim on 29 Feb 2012 08:01:34 AM
Quote from: charon on 29 Feb 2012 07:43:39 AM
not RS...AS and QS ;)

Or am i misinformed (again)  ;D

Nope. Business Insight Advanced was supposed to replace Report Studio. They were going to leave RS out of 10.1 but then decided not too. THANK <insert your preferred deity and/or expletive here>. And also thanks to good beta testers with strong opinions. ;)

Can you image? Anywho, I think BIA still needs a ton of work before it comes anywhere close to replacing RS. But that's just IMHO.
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: MMcBride on 29 Feb 2012 12:45:09 PM
The way I understand it BIA Replaced the "express author" of Report Studio, in 8.4.1 there were two author modes Express and Professional, in 10.1.1 these Author modes are gone (but the references are still there in the Admin panel) but BIA is Express and Professional is good old RS.

BIA has it's upside though.

if I want to make very quick and easy dashboard objects with little to no fuss and basic functionality BIA works wonders, but so far thats the only good use I have found for it.
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: MFGF on 02 Mar 2012 04:44:04 AM
Quote from: Grim on 29 Feb 2012 08:01:34 AM
Nope. Business Insight Advanced was supposed to replace Report Studio. They were going to leave RS out of 10.1 but then decided not too.

Ummmmmmm. Nope. Business Insight Advanced was aimed at business authors, not professional authors, and was designed to kill the complaint of business authors having to "studio hop" to do reporting, analysis and financial reporting. BIA is built on the same code base as RS (like Express Authoring mode in C8) to provide interchangeability from business to professional authoring and back again, but there was never a real intent to replace the RS interface with BIA in this release. This thinking goes back to before BIA even had a name - it was labelled BUXA pre-beta (Business User Experience - Authoring) along with BUX for Business Insight.

Cheers!

MF.
Title: Re: Filter Value in Report Header in Business Insight Advanced
Post by: charon on 02 Mar 2012 08:00:35 AM
 :D thx for the INSIGHT muppet master

and i have to say, i DO like business INSIGHT (Advanced)...its just a pity that i can not directly use textvariables or use layout calculations...i intent to use them a lot in rs

have a nice weekend cognoisers :)