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 -
Hi all, Has anyone found a sensible approach to extract large volumes of snapshotted data out of Birst as as one-time extract? (100m rows+) eg Last 3 years of data for Open Order status and $ amount as of a certain date This snapshotted data doesn't exist in the database supplying Birst.. only in Birst itself, which…
I have 2 spaces named Source (where the extraction occurs) and the Dimension. Let's say I have an ADR Raw Source named M3_OCUSMA_Extract, should I wrap it first in a scripted source (named M3_Customer) and import it to the Dimension space via Package? Or M3_OCUSMA_Extract will suffice? I had issues when modifying the…
I am trying to use DatePart in a custom expression in Visualizer but keep getting the dreaded 'Unable to Apply Filter to Measure' error. I thought DatePart was the correct syntax to use but I must have lost my mind somewhere along the way… This is the expression - [Check Date: Sum: Time Record Item Hours] WHERE…
Hi Team, We have a report that shows the number of records. We want to get the total records in the report and show the total report in KPI Dashboard. May we know how can we do this?
Hello everybody, the source properties of a column was change from string (original format) to float. The column contains data like "8,5" but in Birst, data became "85". Is there a solution to get the information with the right format ? Thnaks ind advance for you Help
It looks like you're new here. Sign in or register to get started.