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 )
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?
How we drill up week to month?
Is there any other repository domains rather than universe, security, document?
What are the steps to be taken to schedule the report?
what will be the contents for a functional requirements specifications
how many reports have u created ? explain a few.
how get the grand total in master-detail report?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What is the difference between the public object&schema object?
Explain what three things do you consider to be the most important factors for a manager?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What is aggregate table and aggregate fact table ... Any examples of both?
Can we Save (save as) WEBI Doc as DESKI?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....