Print Page - Renaming the value prompt values

Title: Renaming the value prompt values
Post by: kvchowdary on 18 Jul 2016 12:59:35 AM

i have a product names value prompt in my prompt page and my user wants the below requirement
Have a checkbox to flag a renaming of the Producs, which when checked will refresh the screen with table listing the user selected Product IDs and a text box next to them allowing the user to enter the new product name. Not all of the product ID rows need to be populated with new product names.And not performing the act of checking the flag will allow for the avoidance of unnecessarily refreshing the screen.

cognos version 10.2.1 and oracle db
is it possible?

Title: Re: Renaming the value prompt values
Post by: sdf on 18 Jul 2016 04:20:46 AM

correct but are you trying to write back to your source (oracle) from a bi report?

Title: Re: Renaming the value prompt values
Post by: kvchowdary on 18 Jul 2016 04:32:15 AM

Hi,

thanks for response,yes

Actually as per my understanding,whatever they selected products,they want to be renamed?..is the above sentance is saying same?

I am confused on that statement.Please clarify me..

Title: Re: Renaming the value prompt values
Post by: hespora on 18 Jul 2016 04:43:33 AM

Barring the use of JS to do this, it would certainly be possible to hardcode this using two prompts per unique value: One to specify the original product name as on the datasource, and one to specify the new name. Then in your report, instead of the product name, use something like

Code Select

case [product name]
when #sq(prompt('OrigName1','token'))# then #sq(prompt('NewName1','token'))#
when #sq(prompt('OrigName2','token'))# then #sq(prompt('NewName2','token'))#
...
else [product name]

The whole issue is with the number of unique product names that you have - if there's ten products and the user wants to rename a max of three, that is still feasible. If you have a hundred product names and the user wants to rename 50 of them, then that's a little less fun to do.

I don't quite see a way of making this dynamic. Inserting a prompt into a data container will not create different prompts, but just different instances of the same prompt. If you enter different values into those, cognos will just use the first value.

I just gotta ask though: *Why* would a user want this? If the product names on the data source are crap, change them. I know that if any of my users came to me with that request, I would grill them thoroughly to understand why they want that, and only then slap them with the CI/CD manual opened to the page stating specifically that our brand names are not to be altered.

Title: Re: Renaming the value prompt values
Post by: kvchowdary on 18 Jul 2016 05:00:07 AM

Hi

Thanks hespora,

I have more than 400 products but dont know which product they want to rename in the list,the user is asking the feasability to do it
i dont know why they wanted to rename..

Title: Re: Renaming the value prompt values
Post by: sdf on 18 Jul 2016 07:52:51 PM

Hi,

You can check this blog from CognosPaul. http://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/ (http://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/)
Here he's adding comment per row. As for your requirement it should alter the product name of what ever is selected by the user.
Is this something similar to what you want to happen?
Though the blog used sql as db, im not sure if it has any equivalent procedure with oracle..

Title: Re: Renaming the value prompt values
Post by: kvchowdary on 19 Jul 2016 12:31:06 AM

Hi

Thanks sdf

Actually my requirement is different..please find the attchecd screenshot

Is this functionality is possible in cognos?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchowdary on 18 Jul 2016 12:59:35 AM