Interested to Buy Any Domain ? << Click Here >> for more details...
I have two data providers with common dimension and
measures. The only difference between two data providers is
in condition 'Fiscal Year'.One data provider calculates for
current year and other one calculates for previous year. So
in prompts if I am passing 2008 as current year then the two
data providers should be able to calculate for current year
and previous year individually.
So Can anybody tell me how to do calculation in data providers.
( I am using BO WebI report )
- 6 Answers
- 12186 Views
- Exilant, Siebel, I also Faced
- E-Mail Answers
Answer Posted / bibin
edit sql in dataprovider ,
Date >= add_months(date),-12
and then check "do not generate sql before running" option.
regds
bibin
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What is difference between webi and infoview?
explain in detail about type 3?
what is xcelsius architecture?
what will be the contents for a functional requirements specifications
How many universes can be created in a project?
When we use aggregate awareness function in designer?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is top business?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
What are the steps to do to use alerts in bo?
Explain how to schedule the report in b.o?
What we need to discuss with designer before starting the universe designing.
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Can we create universe with no cache??
