I am using a lower grain to lookup a higher grain which results in more than one row in Visualizer. The code is below. There is more than one work unit key per Member Organization (HR Organization Unit Level 2), which is why I am getting duplicate rows. LOOKUPVALUE(0,[Work Unit.Work Unit Key],1,SELECT [HR Organization…
We have deployed several dashboards for HCM and use the standard GHRBirst roles to control access. Specifically we use the GHRBirst-HRGeneralist which allows access to all employees and the GHRBIRST-DirectSupervisor which allows access only to that specific Supervisor's hierarchy. We do have 1 dashboard where we would like…
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…
It looks like you're new here. Sign in or register to get started.