CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.




Get it now !!
Send your Resume to 6000 Companies

Search Interview Questions

Question: How to create cascade prompt in cognos impromptu.
Please tell step by step information.


Answer: Creating and Using Cascading Prompts<br>You can create a series of prompts that show only the values that correspond to the value<br>selected for the previous prompt. These are called cascading prompts. To do so, you create a<br>series of linked reports, each of which contains a filter prompt.<br>Because Impromptu runs each report, the size of the reports affects performance. If you use a<br>large report as the source for a prompt, Impromptu must run the report and read through the<br>dataset to apply the filter. If the information contained in the database does not change very<br>often, it is more efficient to create a HotFile with the data that you want in your picklist, and then<br>use the HotFile in your Query.<br>For example, you open a report, and a prompt appears asking you to select a product type from<br>a list of product types. You select the Environmental Line. The next prompt asks you to select a<br>product line from a list showing only the product lines belonging to the Environmental Line. You<br>select the Sun Block product line, and the report appears showing only the data for the Sun<br>Block products.<br>Steps<br>1. Create the report that you want the user to open.<br>2. Save, but do not close, the report. For each cascading prompt you require, save the report<br>again with a different name for each.<br>3. Go back to the first report you created.<br>4. From the Report menu, click Query, and click the Filter tab.<br>5. In the Available Components box, double click the Report Columns folder to open it.<br>6. Double-click the data item you want to appear in the filter expression.<br>7. In the Available Components box, click "In" or "=", and click the left parenthesis.<br>For example, Product in (<br>8. Double-click Prompt Manager in the Available Filter Components box.<br>9. Click New to create a prompt.<br>10. In the Prompt Definition dialog box, type a Name and a Message for the prompt.<br>11. In the Type box, click Report Picklist.<br>12. Locate and select one of the reports you saved in step 2.<br>13. In the Report Data box, select the data item that the current report prompts for, click Use,<br>click Display and click OK.<br>14. Click OK to close the Prompt Manager.<br>15. Complete the filter definition by double-clicking ")" in the Available Components box, and<br>click OK.<br>For example, Product in (?Product Name?)<br>16. Open each of the reports you saved (other than the first report you created in step 1), and<br>edit each report so it contains the required data items, and the appropriate filter definition<br>containing the desired prompt.<br>17. Open the last report and edit it so it is a simple list containing the data item for which the<br>user is prompted.<br>18. Save the report.<br>When you open the report you created for users, you are presented with the series of prompts<br>and lists of filtered values.<br><br><br>Note:- If your using Impromptu V7.3 Admin then this info is in the Mastering Impromptu Reports PDF in the Help Menu under Books Online<br>



Category Cognos Interview Questions & Answers - Exam Mode / Learning Mode
Rating (0.4) By 423 users
Added on 9/21/2013
Views 4938
Rate it!
Question: How to create cascade prompt in cognos impromptu.
Please tell step by step information.



Answer:

Creating and Using Cascading Prompts<br>You can create a series of prompts that show only the values that correspond to the value<br>selected for the previous prompt. These are called cascading prompts. To do so, you create a<br>series of linked reports, each of which contains a filter prompt.<br>Because Impromptu runs each report, the size of the reports affects performance. If you use a<br>large report as the source for a prompt, Impromptu must run the report and read through the<br>dataset to apply the filter. If the information contained in the database does not change very<br>often, it is more efficient to create a HotFile with the data that you want in your picklist, and then<br>use the HotFile in your Query.<br>For example, you open a report, and a prompt appears asking you to select a product type from<br>a list of product types. You select the Environmental Line. The next prompt asks you to select a<br>product line from a list showing only the product lines belonging to the Environmental Line. You<br>select the Sun Block product line, and the report appears showing only the data for the Sun<br>Block products.<br>Steps<br>1. Create the report that you want the user to open.<br>2. Save, but do not close, the report. For each cascading prompt you require, save the report<br>again with a different name for each.<br>3. Go back to the first report you created.<br>4. From the Report menu, click Query, and click the Filter tab.<br>5. In the Available Components box, double click the Report Columns folder to open it.<br>6. Double-click the data item you want to appear in the filter expression.<br>7. In the Available Components box, click "In" or "=", and click the left parenthesis.<br>For example, Product in (<br>8. Double-click Prompt Manager in the Available Filter Components box.<br>9. Click New to create a prompt.<br>10. In the Prompt Definition dialog box, type a Name and a Message for the prompt.<br>11. In the Type box, click Report Picklist.<br>12. Locate and select one of the reports you saved in step 2.<br>13. In the Report Data box, select the data item that the current report prompts for, click Use,<br>click Display and click OK.<br>14. Click OK to close the Prompt Manager.<br>15. Complete the filter definition by double-clicking ")" in the Available Components box, and<br>click OK.<br>For example, Product in (?Product Name?)<br>16. Open each of the reports you saved (other than the first report you created in step 1), and<br>edit each report so it contains the required data items, and the appropriate filter definition<br>containing the desired prompt.<br>17. Open the last report and edit it so it is a simple list containing the data item for which the<br>user is prompted.<br>18. Save the report.<br>When you open the report you created for users, you are presented with the series of prompts<br>and lists of filtered values.<br><br><br>Note:- If your using Impromptu V7.3 Admin then this info is in the Mastering Impromptu Reports PDF in the Help Menu under Books Online<br> Source: CoolInterview.com

Answered by: RJ | Date: 6/26/2009 | Contact RJ Contact RJ


If you have the better answer, then send it to us. We will display your answer after the approval

Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.

Post your answer here

Inform me about updated answers to this question.
Related Questions
View Answer
In my report contain Product name, Amount, Country, Sales person.
I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.
if u select the Asia in prompt page-?ll Asian country results I want in report page.

I discussed with my friends and colleague, they told use the static choice function.
Still I face this problem. if u know please tell me?
View Answer
Suppose you run a report with empty data , how will you inform the end user that it has no data ,while running the report in report studio?is it possible , if so how?
View Answer
What is the difference between enterprise data warehouse and data warehouse?
View Answer
What is Zero-foot print?
What are the other methods working as deployment functionality?
View Answer
What you mean by Drill across and what is the difference between drill through,drill across?
View Answer
What is transformer?Can anybody explain it.
View Answer
1.what is difference between PAGE BREAK and Section Report?

2.what is Main Advantage Datawarehousing over Oracle?
View Answer
How to publish powerplay reports using PPES?
Explain the steps??
View Answer
What is the difference b/w macros and prompt?

View Answer
what is meant by alternate drill down with ex?

View Answer
How can I create a dynamic column name in Cognos

View Answer
use this query i am retriving all years OCt data from 01-10-2004 to 30-10-2007

i need to restrect this query to current date and current year

[gosales_goretailers].[Orders].[Order month]between 01 and to_number(to_char(current_date,'MM'))and [gosales_goretailers].[Orders].[Order month]=to_number(to_char(current_date,'MM'))
pass polar ID

View Answer
What Junk Dimension contains?

View Answer
What is meant by Junk Dimension?

View Answer
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?

View Answer
What is catalog and types of catalogs in cagonos and which is better?

View Answer
How can i schedule reports in cognos

View Answer
How can i test reports in cagonos?

View Answer
How can create users and permissions in cognos?

View Answer
What type problems we can face in general at report runnig time

View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Cognos Interview Questions & Answers - Exam Mode / Learning Mode




India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.03125 Seconds