SQL Query to fetch Flattened Organization Hierarchy Tree
If you have a requirement to fetch the flattened organization hierarchy tree you can use the SQL in this article to get the information.
All posts on BI Publisher
Using Session Variables in BI Reports to get logged in user info
Session variables are used frequently in BI Publisher when the reports are being exposed to employees to add data security on top of the existing query. We need to write query to pull only the logged in user information and for this we will use the session variable. Apart from this user, there are many other session variables and we…
How to modify XML tags in BI Publisher Output?
There could be scenarios where in the client needs the report output in XML format and that XML file will be sent to some third-party vendor and it will be imported to their legacy systems for other processing. And the vendor might expect the XML file with some pre-defined tags for the attributes for them to process the files and…
Execute Reports from Navigator without exposing the BI Catalog
In most of the cases, Employees will not have access to Reports and Analytics to access the reports. However if there is a requirement to create a report and provide access to employees, giving access to Reports and Analytics might expose other reports or seeded reports too, hence it is not a wise decision to provide access to BI Catalog.We…
Security Matrix Users and their Roles
For every implementation, there would be functional consultant who looks into the security and their job is to create a security matrix with all users list and their roles mapped on to a sheet. It would be tough to create this sheet manually when there are 1000's of employees and it doesn't make any sense to do it manually.In order…
Adding hyperlink in Email using BI Bursting
How to add hyperlink to email body message using bi publisher bursting? Have a look at this article to know more information.