-
UPDATE function on scripted source
Hi Team, May I ask what is/are the counterpart function in BIRST ETL script function for UPDATE? Thank you for your inputs
-
Birst Max Numbers
Good morning, I am trying to return the [CAR Number] that is associated with the MAX of my custom measure DateDiff(Day, [CAR Create Date], NOWDATE) WHERE [CAR Close Date] = '1900/01/01'. I am only trying to return one row. So, it would look something like this: Oldest CAR # of Days Open | Oldest CAR # 216 | 245 I can get…
-
connect Birst to Datalake
First time user, sorry to bother you all but where to find data information to connect Birst to our datalake, Datalake is loaded we have replication on.
-
Infor Data Lake Connector LMTS from DateTime to Integer
Hi, we want to use the Infor Data Lake connector, but noticed that the LMTS field comes back as datetime. The original one was integer. We don't want to have to rebuild some of our tables to how can I convert the new LMTS datetime back to the 13 digit numeric value that the sql data lake connector returned? Tina
-
Positional Calculation Help
Good Morning, I need some guidance on a positional calculation. I am trying to get the percentage of the total MRR's by QC Reason Code. The tools on Infor's website are not very clear on how the positional calculation works. It doesn't really provide context as to how the [Products.Total] field works and where it comes…
-
Help Identifying Jobs to Populate M3 Analytics Dashboards in Birst
Hi Birst Community, I’m new to Infor’s Birst and M3 Analytics and trying to understand what jobs need to be scheduled in M3 to ensure that key statistics are populated and available in the analytics dashboards. For example, I know that for Procurement, supplier and purchasing statistics need to be scheduled to run, but how…
-
Labor Hours Remaining by Workcenter per Job
Hello, I have a report where each record represents a different job. I'm trying to write a BQL query to calculate the total number of labor hours left at each workcenter based on how much of the job has been completed. Basically, taking Job Qty Released minus Job Route Qty Completed and then multiplying that result…
-
Graining Issue/Challenge
Hello, I created a source called "ProQuote" that pulls from MSSQL. It has a key field "Trailer Numeric Sequence" that also exists in another source "Trailer Master" and this field name is the key to this source. I had linked to "Trailer Master" before without issue. Not sure why after graining, I extract/publish, and the…
-
Visualizer & Designer Gone
I created a test space to connect to a new MSSQL database and everything seemed to work fine. I was able to extract data and publish separately fine, and even create a report in Visualizer. I then scheduled an extract/publish and let that ran. Afterward, Visualizer and Designer is no longer there. Is there something I need…
-
Designer Version
What version of Designer does my instance have? There doesn't seem to be any courses about Designer, and when i use Google or ChatGPT for help, every reference takes me to "Classic Designer", and the instructions and screen shots don't match what I'm working in.
-
UTC to CST report expression
Does Anyone have a 'magical' report expression that converts the fields RGDT and RGTM which is UTC time?, to CST Date and Time? Thank you in advance
-
Report Level Drilling for Custom Attributes
Hi All, I'm building some reports in visualiser and I have a custom attribute which is as follows: IIF([Payer.Payer] = '-','Legacy Payer(s)', [Payer.Payer]) I need [Payer.Payer] to drill across to [Item.Item] on my report but it does not seem to work. I have tried the following: - Setting a drill path from [Payer.Payer] to…
-
Default Subject Area not displaying added database tables
Using Appliance BIRST 2022.06 Using Live Access BIRST Connect 1.0 (classic connection with jnlp file) - SQL Server Added new database tables to my space using Import because Flash no longer available for classic connection New tables all added correctly in Modeler Prepare and relate. However, tables are not in DEFAULT…
-
Can we publish a Birst report into an external application/HTML frame ?
We would like to know if we can visualize a Birst report in an external application? For example in iframes within Hubspot. Are there REST api's available to do this?
-
Creating Custom Models in modeler
I am creating a custom model in modeler. Where could I see the source table names to write the SQL query to connect a table in infor WMS.