My current blog looks at the logical or business model. In particular how to connect fact tables so that you can get numbers from more than one fact in the same report – and actually show results. This aspect of OBIEE seems to cause a fair...
Read MoreRecently a client came up with a requirement to host externally-generated PDF reports in OBIEE and have them display alongside their other OBI content. They also wanted these files to be searchable by name like the rest of elements comprising the web catalog. To achieve...
Read MoreCreate an analysis in Excel using SmartView and save in OBIEE catalog Using SmartView add-in, we can create OBIEE reports from Excel/Word and save in OBIEE catalog.And we can see those reports within OBI Presentation services and can use it for further analysis. To create an OBIEE...
Read MoreWhen the results of an analysis return no data, the following default message is displayed to users: We can modify the No Results view, by adding custom message or more explanation on the use of report or hints on how to filter values. We can also change...
Read MoreRecently I came across a customer requirement to allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly’ or ‘Monthly’ and the appropriate sections of a dashboard would be shown. To achieve this I...
Read MoreHow was it done? I created a basic report: The last column has no meaning, we just need something to be in the measures part. In my case I decided to have a column of NULLs with space as a label. So I create a Pivot: And rearrange it: Now...
Read MoreOne of the main problems of Narrative is the lack of drill options, what is called now "Navigate to BI Content". On the other hand, it can be easily achieved using basic scripts and GO URL. I will do a basic example, for more detail on...
Read MoreThere will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside,...
Read MoreBursting is a process of splitting data into blocks, generating documents/output for each block and delivering the documents/output to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a key value (e.g....
Read More