There have been changes in 2025.02 for copyspace and duplicate space (from the global navigation bar + menu). Please take a look at the KB3569756 article in ServiceNow for important information about data movement. *if there are issues with the link, open ServiceNow through Infor Portal/Concierge and search for the article.
I have two measures, [Delivery Date: Sum: Releases Delivered] and [Delivery Date: Sum: Releases Delivered On Time]. Each gets set to a value of 1 or 0 depending on the order release status. I'm trying to do a basic on time delivery calculation, but it keeps returning the number of releases delivered instead of the…
When designing or personalizing reports, I use Report Designer. I cannot transform the layout of the data visible in the rows - SELECT ABCDE001.VALUE1, ABCDE001.VALUE2 FROM ABCDE001 VALUE1 VALUE2 10 100 55 550 24 240 On the arrangement of data in columns (pivot) VALUE1 10 55 24 VALUE2 100 550 240 How to make such a…
I am trying to perform either (* or / ) between two records however the output is always 0. However whenever I tried to + or - operations, it works. Lets say: Column 1: Value 20 Column 2: Value 10 I tried this → SavedExpression('Column1')/SavedExpression('Column2') and the output is always 0. What am i doing wrong?
I want to export the dashboard using the top right button that converts it to a printable pdf. This does not work and it shows download failed. What can be the reason for this and how could i fix this?
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…
It looks like you're new here. Sign in or register to get started.