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?
Answer Posted / 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 |
Post New Answer View All Answers
Can Bo generates the Report from the cubical data Explain?
Can we configure two instances of CMS pointing to two different CMS system databases?
how many reports have u created ? explain a few.
Explain when we use aggregate awareness function in designer?
What is the difference between user and versatile user?
8. How much supervision have you typically received in your previous job?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What is top business?
What is the difference between condition & filter?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What is the difference in creating filters in designer and business objects?
What is the difference between slice and dice and cross tab report?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?