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…
I have a fact table that's set to refresh based on a delete key. However, I noticed that the table is retaining multiple copies of that key as each processing occurs, where the only difference in the record is that the time.day field increments by one. Any idea why this is happening and how to resolve?
Hi, I have a requirement to count all employees reporting to the managers and it can be direct count and total reporting count. For example, I have a data like this and we want to display the 2 calculated measures by employees: In Power BI there is a function PATH() to handle the requirement. How do we do this in BIRST…
Can the quick upload option in Connect be restricted based on security roles? I was under the impression that no matter which license a client has (enterprise or professional) both the data lake and quick upload would always be available, but this is all I see when I click on Connect -
It looks like you're new here. Sign in or register to get started.