Cascading "values prompts" in Report page.

[Revathi_M]

my version:10.2.1
using Report page

my senario i have 5 parameters each have cascading parrameters.

i have one button on  button "display" when click the button that time only refresh my report that way i am using auto submit is NO

i need cascading  1st  values prompt to 2nd values prompt and 2nd values values prompt to 3rd values prompt. in report page itself only

if any help me

Thanks
RevathI_M

[MFGF]

my version:10.2.1
using Report page

my senario i have 5 parameters each have cascading parrameters.

i have one button on  button "display" when click the button that time only refresh my report that way i am using auto submit is NO

i need cascading  1st  values prompt to 2nd values prompt and 2nd values values prompt to 3rd values prompt. in report page itself only

if any help me

Thanks
RevathI_M

If you think logically about this, it's not going to work. You can't display the page with the report container on it (list/crosstab/chart etc) unless all the parameters have values to fulfil the query. You could define default selections for the initial view of the page, but as soon as you change one of the prompts to something else you have to submit the page to get the next cascading prompt to refresh. By submitting the page, you automatically run the queries for all the prompts plus the main query too.

In a nutshell, don't do it. If you have cascading prompts, use prompt pages.

MF.

[spmaganti]

There is a great article if you want to achieve this kind of out of the box functionality using JavaScript.

http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html

[Lynn]

There is a great article if you want to achieve this kind of out of the box functionality using JavaScript.

http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html

Sorry to sound nit-picky, but if you are using JavaScript then it isn't "out of the box". My advice is to follow the Muppet's advice, but if JavaScript is absolutely necessary then make sure you understand it, document it, and that all those on your team are well able to support it and fix it if it breaks on upgrade.

[spmaganti]

Agreed with Lynn's comment. It should read "Outside the box" rather and second rest of the comments..

[rotger10]

We have the same challenge in our organization. All of our reports use in-report prompts, and the out-of-the-box cascading property, although it works as designed, was not ideal for us for different reasons. First, prompts using a cascading source had to be in a hierarchy and were not available until a value from the cascading source prompt was first selected. In our case, prompts need to allow any desired values to be selected before applying to a report. Second, when using multi-select prompts, the autosubmit was problematic because it would submit after each value was selected (not a problem with single select prompts) - not fun when prompts have many values. Lastly, we are trying as much as possible to design reports without having to rely on custom coding javascript snippets.

A work around we have found is using detail filters in the prompt query to populate the prompt vs. using autosubmit/cascading properties. For example, take 2 value prompts - State and City (both part of a geographic hierarchy).  Where the City prompt would typically use the State as the cascade source, we did NOT enable cascading but rather we used a detail filter in the City prompt query so the values for the City prompt populated based on what the user selects from the State prompt. This keeps the prompts accessible by users vs the cascading which disables the prompt until the cascade soure is selected.

This seems to work well for hierarchies but we have not been able to get it to work yet where a hierarchy doesn't exist. If anyone has any advice about whether that can be done or not before we go running down a rabbit hole that would be most helpful.

[Revathi_M]

still i am not solved this isue.....
please anybody help me with XML file


please this urgent me...........................

i am follow below links above given exports

my version 10.2.1
using relation data base


have two panel left side panel is all 'values prompts' and right side is List

left side panel 6 prompts
i need to auto cascading in report page

region prompt cascading 'country prompt' and 'country prompt' cascading to 'store prompt'

here i am given auto submit is 'NO' becouse i am using button "Display" when click the button only to display data in List

[navissar]

There is a great article if you want to achieve this kind of out of the box functionality using JavaScript.

http://www.ibm.com/developerworks/data/library/cognos/reporting/advanced_report_design/page583.html

Actually, this solution has some issues (Doesn't handle different use/display values, and requires code changes to set up). There's a newer one addressing these issues, using JS (But doesn't require code editing). And it was written by a man who is arrogant enough to link to it here :)
http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page673/index.html
This could be set up and used to cascade the prompts without refreshing, thus not running the report...

[navissar]

I got the following personal message from Revathi_M today:

hi nimrod,

itryed total today still no autocascading in report page not prompt page



please can do R&d in report page send me xml file............
please plase plsea  this urgent only this issue my report not delivery ,,please man help me

Revathi_M, please review the forum etiquette.Specifically, please:
When something is not working for you, specify precisely what isn't working, don't just say it doesn't work.
Don't put members on the spot by sending them direct messages, it comes across as pushy.
When you ask someone to do your development for you and send you their work product rather than do the work yourself, you come across as rude and demanding.
When you mention repeatedly that something is urgent for you, it also doesn't help: It makes you seem very pushy, and antagonizes people. Please don't do that. 

[Revathi_M]

Hi all,
This code working in prompt page
but ineed in report page ig any explain me where i change it work in report page

thanks

[Michael75]

@ Revathi_M

Apparently it is necessary to explain things very very clearly to you.

When Nimrod mentioned the forum etiquette, he was referring you to this post: http://www.cognoise.com/index.php/topic,24030.0.html

Clearly you have either not read it, or not understood it. But the good news is that you don't need to, because Nimrod kindly condenses its salient points for your benefit:

When something is not working for you, specify precisely what isn't working, don't just say it doesn't work.
Don't put members on the spot by sending them direct messages, it comes across as pushy.
When you ask someone to do your development for you and send you their work product rather than do the work yourself, you come across as rude and demanding.
When you mention repeatedly that something is urgent for you, it also doesn't help: It makes you seem very pushy, and antagonizes people. Please don't do that. 

And yet you have apparently not read or understood this either.

All we have learnt from your latest post is that the cascading prompt technique "does not work" in a report page. Your repeated refusal to give details (error messages, precise info about how your prompts are behaving...) makes it nigh on impossible for the good folks on Cognoise to give you any further assistance.

It's your choice...

[navissar]

I got the following PM from Revathi_M and I thought it's worth it to give other forum members a bit of a heads up, maybe warn other members before they receive such misguided, disagreeable messages.

nimod,
i am working small company,i started 2 month back learning cognos my project starteded dec 10, it finish this project jan 5. later i am working my old technology
this project  handle 2 people i am cognos report studio and other man frame work.
my company only got only one project for cognos that is local company.it finish jan 5



if u didn't times to replay answer please don't login forum.

ur more experience in cognos don't behaviors like that


first learn what is forum ,forum mean sharing knowledge..........



don't feel u r grate talent man
when u r started learning cognos u r also sending like tha only



don't mind my words

thanks
revathi_M 




,after jan 5 i am not part of this corum  fognos

[MFGF]

I got the following PM from Revathi_M and I thought it's worth it to give other forum members a bit of a heads up, maybe warn other members before they receive such misguided, disagreeable messages.

Hmmm. I got a similarly disagreeable message from the very same member:

u r company not given salary

i tryied that i am asking

i am new in cognos it is only one project that 3 month duration


that way i am asking...

if u r not time don't login in forum....

Revathi_M, please behave in a polite and civilised manner if you wish to remain a member of this forum. Please read and make sure you fully understand the forum etiquette post, linked to above by Michael75.

Thank you.

MF.

[Lynn]

In an attempt to maintain some sort of cosmic balance in the universe, let me express heartfelt thanks to all of you out there who give so freely of your time and talent to help people on this forum.

There are, sadly, some members here who either fail to offer a simple "thank you" or, as in this extreme example, show downright arrogance and a meanness of spirit in their expectations.

I know that I, along with countless others, have learned so much from the excellent information and advice offered here.

Wishing you all a very happy and healthy New Year.

[navissar]

Ah, Lynn, always the peacemaker and the benevolent bestower of cosmic positivity (Or is it positiveness?)
It's a good chance to say I, too, learn so much from the good people of this board, present company included.

Have a very happy new year yourself!

[Michael75]

Ah, a sweet touch of femininity from the hallowed Lynn in the testosterone-fuelled arena that is Cognoise  :-*

Happy New Year to all
Michael

[CognosPaul]

A little late to the party, but I figure I might chime in now. A lot of people have been requesting a solution for a non-refreshing cascading prompt that doesn't require pre-loading all of the data. I've brought it up with the design team, but I don't know if anything will happen with it.

Instead I've been spending the past few months trying to build a better cascading system. The solution I have right now works, but there are two reasons I haven't published it:

1. It's still too complicated. In order to use it the developer needs to write a JSON array with the prompt names and where it cascades to/from and what parameters are required. I'd like to build a small applet that will let you enter the names of the prompts, and select what cascades to what and have it spit out JSON.
2. Monetization. I'd hate to sound greedy, but I've been working on this a few months. My idea is to release two versions, a free one that simply cascades from one prompt to another, and a paid version which supports cascading to/from multiple prompts. Also, if I do sell it, I'm trying to figure out the correct price.




Hopefully I'll have a working copy (even if it is cut back on features) on my blog sometime over the next few weeks.

[intrepid402]

Thanks for the reply, CognosPaul. Looking forward to that solution :)

Also those messages by Revanthi made me cringe.  :-X

Kudos to handling this well :)

[chiz]

2. Monetization. I'd hate to sound greedy, but I've been working on this a few months. My idea is to release two versions, a free one that simply cascades from one prompt to another, and a paid version which supports cascading to/from multiple prompts. Also, if I do sell it, I'm trying to figure out the correct price.

Hello, what about your versions?