Next on the list… cross drilling. In dimensional modeling terms, we refer to this as “drilling across”… as in “drilling across fact tables.” We do this when we need metrics from two or more fact tables in the same analysis. This is easy when the analysis is using all conformed dimensional attributes. In most cases, […]
OBIEE 11.1.1.7.1 Cross Drilling: Read More »
OBIEE, TipsSo it seems that by default, BI Publisher uses CSS style sheets as opposed to inline CSS when generating reports in HTML format. This is perfectly fine as the reports render fabulously in our favorite browsers. However, in certain popular browser-based email services like Gmail, Hotmail, and so on… not so fabulous.. I first noticed
Emailed BI Publisher Reports in HTML Format Not Showing Properly Read More »
BI Publisher, TipsOverview: Working with a bursting BIP report to be sent out to X number of recipients. The bursting job never completes and stays in ‘Job processor completed’ status indefinitely. Looking at the job details, N number of recipients’ reports are created and delivered. M number, however, are stuck in ‘Rendering Report Document’ statuses. The BIP
BI Publisher Bursting Issue Read More »
BI Publisher, TipsWhile I was looking into a calculation issue today for a calculated percentage, let’s say the formula is ((b-a)/c)*100, the numbers just were not coming out correctly. Actually they were all coming out to 0! I know this was not right, so I investigated. I looked at my physical query and noticed OBI was creating that
Weird Results When Calculating Percentages or Ratios… Read More »
Tips