In our project we are blocking the obiIe issue as described below. Please suggest that there is no way to get this solution in OBIIEE or it is not possible through this tool. We tried in a lot of ways, whatever does not work.
We have estimated forecasts / budget data as thousands in the database table, we need to show the data in the nearest million. The report has been developed in pivot view with some signals.
The report needs to show data in about one million for the report and when Excel is downloaded, then this data should be shown in millions, so that the whole number should be in the background so that they Can manipulate with it. (In Excel on selection it should show the actual number with decimal) The following are the technical specifications used in the OBII report: formula = forcast / 1000 data formats - & gt; Override default data format - & gt; Decimal place - & gt; 0 When we export this report to Excel, it exported data to millions, but if they want to see the whole number for manipulation, then the following are examples: Thousands of database data: 5,977.71 OBEI report should show value in millions: 6 To achieve excellence, it should show data in one million: 6 With above situation, business use Gkrta can no longer use the data because it is not available in the data export Excel background. In the background of export excellence requires 5,977.71 so that they can manipulate (like they can add or subtract data and change goals in million). I'm not sure you can do this. You can try, hide the columns in the report and then download it. You can get both columns (round and full numbers) in the XLS file.
No comments:
Post a Comment