Renaming the value prompt values

[kvchowdary]

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?

[sdf]

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

[kvchowdary]

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..

[hespora]

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 Expand

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.

[kvchowdary]

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..

[sdf]

Hi,

You can check this blog  from CognosPaul. 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..

[kvchowdary]

Hi

Thanks sdf

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

Is this functionality is possible in cognos?