Hello and welcome to the official Birst forum, a part of the Infor OS Platform community. We're excited to have you here and look forward to fostering a collaborative environment where users can share knowledge, ask questions, and explore the capabilities of Birst. 🚀 About This Forum 📌 This forum is dedicated to…
Hi Team, May I ask what is/are the counterpart function in BIRST ETL script function for UPDATE? Thank you for your inputs
Good afternoon, I'm trying to create a KPI for a dashboard called "Win Rate %." I am trying to take the SUM of the first column (CO Line Flag) and divide it by the count of the 2nd column. So, in the below example it would be 9/10 = 90%. Here is the report expression I'm using the CO Line Flag: IIF([CO Create Date: CO Line…
What is the proper syntax for COUNT DISTINCT in a Prepare Script?
I was told that my ER 109130 (Top N by Selected Attribute) will be archived July 1st if it doesn't receive enough upvotes by June 2nd. It already has 7 upvotes so I'm not sure how many more are needed, but if you can support that would be really helpful, as this is a much needed feature that several of us are interested…
Hello, I'm trying to use item code as join key, but I'm not getting a match. The table on the left(Table1) is the one I use on my local DB with Enterprise connector, and the table on the right(Table2) is the one I uploaded from LN to Datalake. The item codes in the local DB don't seem to have any spaces in them, is there…
Any idea how to implement Gantt Chart in BIRST? For example, I have fields: Process Start Date End Date
I am trying to set up my MSCM replication for the first time. Following the documentation I ran CSF-Reset Extract Variables - YYYY-MM-DD. However it failed with the message below - I need some information on how to fix this. Step: Step-1 Task Type: SetVariable Reason: The variable AllExtractDate could not be updated since…
I have a requirement to view the employee count by manager (employee ID) and also view it by Country only. As you can see, there are 12 managers who are correctly showing the emp_count, and another measure showing if they are managing employees more than 10 (3 managers). When I want to see the value by just the Country…
Hi. I am trying to make some security with a report in Birst (Designer View) using Advanced Filter. The logic is, if the user is an authorized user, filter it with a specific country, if not then else. I am not sure what is the best structure of the expression and if <EVAL!> is an acceptable function in the filter <EVAL!…
Is it possible to use a QBO in Birst Connect to pull all variations from the data lake? Similar to how in Compass you can query using "from infor.AllVariations('table') to pull all variations that exist in the data lake, including deleted rows and overwritten rows? We are currently keeping a separate table for historical…
It looks like you're new here. Sign in or register to get started.