Quick question. If we have two records going into a script with a source that has 5 columns as the key, but we are only setting up our LK with 4 of the fields. If, within one scripted source run, there is two records as follows, would it insert both as it doesn't know the LK exists in the previous record yet to do an…
Is there a flag field or some other way to identify if the customer is in standard or daylight savings time? I have created a BQL expression for Pacific time using DateAdd which will work until 11/03/2024, when DST ends. DateAdd(Hour,-7,NOW) Ideally I would like to avoid having to edit the expression whenever the time…
I have found an interesting info here: It talks about the well-known issues with averages at the Summary level in reports. Specifically, it says: Birst has an account level setting called ‘LegacySummary Flag’. Only Infor can turn this on by submitting a support ticket. Once enabled, the summary operation ‘expression’ works…
For the sake of example, I made a table in Visualizer to simply list the line numbers in a sales order. When I check the order in CSD, I see that there are 26 lines (27 including an inactive line). In Birst, only line # 19 is listed. However, if I add a Quantity Ordered column (or other Measure from Sales Order Line) to…
What is the proper syntax for creating multiple IF THEN conditions in a scripted source in Birst? IF [MWRA_Enrollee_file_1.PlanCarrierCode]='A1C' THEN [PlanCarrierCode]='LBAS' ELSE IF [MWRA_Enrollee_file_1.PlanCarrierCode]='A1D' THEN [PlanCarrierCode]='LLTD' ELSE [PlanCarrierCode]=[MWRA_Enrollee_file_1.PlanCarrierCode] END…
2025-01-15 20:17:02,761+0000 INFO - Finished ST_ICSEU_CS 2025-01-15 20:17:02,818+0000 INFO - Loading directly from script output - ICSEU_CS.txt.tmp 2025-01-15 20:17:02,828+0000 INFO - Bulk loading staging table ST_ICSEU_CS from source file C:/Birst1/Production/[CUSTOMER_PRD-SX-Source]/data/ICSEU_CS.txt.tmp 2025-01-15…
Is there a way to make tables within your birst dashboard ignore embedded filters so if you filter the table stays untouched?
Hello, I would like to modify the Perfect Line expression on my custom space, but I have no idea how I can summarize the Net Amount LC based on the sasa Shortage: MAX([sasaPlanned Receipt Date: Sum: sasa Net Amount LC] - [sasa Planned Receipt Date: Sum:sasa Shortage] - SAVEDEXPRESSION('sasa Late'), 0) I also tried to…
Hello, Is there an option when doing a query based object in connect to only get the current records for an initial load…similar to if i query in compass? We are loading a new fact table and there is no reason to bring in 100+M records to get the current record.
Hello Team, I wanted to inquire if there is an existing dashboard available to monitor the APIs hosted on ION. Specifically, I'm looking for the following features: Traffic on the API within a specified time range. A count of errors that occurred during that time range. Detailed logs, including the requests received during…
It looks like you're new here. Sign in or register to get started.