I HAVE USED A PROMPT TO SELECT A COUNTRY
IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN
DEFAULT AND HAVE TO GIVE THE RESULT?
HOW TO ACHIEVE THIS?
Answers were Sorted based on User's Feedback
Answer / satish yandamuri
You just drag the country object in filter object select the operand as promt, then left side of the operand you could see blue color bubble when you double click on that you will get a promt properties, there you can see the default LOV option, there select India as a default LOV, then when a movement you refresh the reprot, it will show India as default LOV.
Cheers,
Satish Yandamuri
| Is This Answer Correct ? | 25 Yes | 1 No |
Answer / reddy
yes .We can give value INDIA as a constant into the
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sudhakar
ACCORDING TO YOUR REQUIREMENT I UNDERSTOOD THAT YOU WANTED
TO PASS A DEFAULT VALUE TO YOUR REPORT AS INDIA.
YOU CAN ACHIVE IT BY FOLLOWING BELOW STEPS:
1: CREATE A BLANK REPORT
2:INSERT YOUR REPORT AS A SUBREPORT TO THAT BLANK REPORT.
3:CREATE A FORMULA IN THE BLANK REPORT AS INDIA(WRITE INDIA
THE WROK SHOP)
4: WHILE LINKING THE SUB REPORT YOU NEED TO LINK WITH
PARAMETER AND THE BLANK REPORT FORMULA.
5: SO THAT ON THE FLY PARAMETER GOT ASSIGN TO INDIA
EVERYTIME AND YOU WILL GET DATA OF INDIA IN THE REPORT.
NOTE: YOUR REPORT SHOULD NOT CONTAIN ANY SUBREPORT.
| Is This Answer Correct ? | 0 Yes | 12 No |
i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?
Explain the data types present in bo and what happens if we implement view in the designer and report?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
Difference between Object varification and validation
what are the complex reports you have created. Tell me with example?
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
how to limit number of rows in a report in business objects using webi?
I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM
What is global filters and local filters
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
Tell me the difference between cmc and cms?