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…
Im currently creating a circle diagram that splits the planned receipt dates for order line in days (Monday to friday). It sees it correctly except its counting the day number instead of just one per order line. For example if an order is planned for 30/01/2025 it shows the right day but gives it the value 30 in the circle…
I have a 100 byte fixed length txt file that I need to SFTP into Birst. There are no headers in the file. When I add it to do a quick upload as a test, I receive an error that I need at least two columns to import. I was hoping I could import the file as is (with one column) and then parse it later in Prepare. I am totally…
I have a Space where, among many other things, I have defined 2 Publishing Groups called "Load_1" and "Load_2". For some reason, when I publish them together (in order to have first the Data Warehouse loaded by the Sources in the 1st of these groups, and then the Sources in the 2nd processed - this is done because the…
Looking for some quick advice on orchestration. If I have the following set of spaces for each environment where consumer points to packages in the models and dimensions, models point to packages in dimensions and sources, and dimensions points to packages in sources… TEST-Consumer TEST-Model X TEST-Model N TEST-Dimensions…
It looks like you're new here. Sign in or register to get started.