SQL Query to pull Assigned Payrolls Information
Do you know how to load the AssignedPayrolls and extract that information from the HCM system? Read on to know more details.
All posts on BI Publisher
How to resolve column splitting into multiple rows issue in BI Publisher?
Do you know how to resolve the issue of columns merging into multiple rows? Can the template be fixed to handle this issue? Can we get .xlsx output format? Read on to know more details.
SQL Query to get the Payroll Definition Config Information
Do you know how to extract the Payroll Definition information from HCM? Read on to know more details.
SQL Query to find Worker Count by Person Type
Do you know how to query the worker count by Person Type? Read on to know more details.
How to fetch the flattened Supervisor Hierarchy for employees using SQL Query?
Do you know how to fetch the flattened supervisor hierarchy for employees using SQL Query? Does the query work if there are multiple levels? Read on to know more details.
How to translate BI Report Output to other languages?
Do you know how to translate the BI Publisher Output to languages other than English? How to derive the language dynamically based on user? Read on to know more details.
SQL Query to identify person relationship with Organization
Do you know how to get the Person's relationship with the organization? Candidate, Employee, Ex-Employee, Pending Worker, etc. Read on to know more details.
How to add Hyperlink to the RTF template?
Do you know how to add the hyperlink to fields on RTF template? Read on to know more details.
SQL Query to extract Business objects and attributes enabled for Auditing
Do you know how to extract the Business Objects/Attributes configured for auditing? Read on to know more details.
How to Download and install BI Publisher Plugin for MS Word and Excel?
Do you know how to install the BI Publisher Plugin for Windows for MS Word and Excel? What else is provided with installation? Read on to know more details.