Hello and welcome to the official Birst forum, a part of the Infor OS Platform community. We're excited to have you here and look forward to fostering a collaborative environment where users can share knowledge, ask questions, and explore the capabilities of Birst. 🚀 About This Forum 📌 This forum is dedicated to…
When I try to perform calculations referencing a column that has been brought into the current table using a lookup I receive the error message: 'Failed to process data due to script failure'. It appears that the column is not being recognised. Does anyone know why this is the case? Many Thanks
I am pretty sure the answer to this is no, but I wanted to see if anyone had a workaround to this one - Visualizer allows dashboard users to sort any column in a table, but I do not see that functionality in Designer. Is there a workaround or another creative solution out there? Thank you,
I am having a weird summarization with 3 lines that are the same serial number, but the record key "Trailer Numeric Sequence" is different. All 3 lines have different status, which is Complete, Invoiced, and Cancelled. In my Birst report, I have the Selling Price analyzed by Invoiced Date. Shouldn't it only summarized the…
I created a BQL measure that will default to $0 if the user wants to exclude negative dollar amount from my Report or include it. Below is my syntax. IIF(INTEGER(GetPromptValue('NegativeSellingPriceZero', '0')) = 1 AND [Trailer Invoice Date: Trailer Net Selling Price] < 0, 0, [Trailer Invoice Date: Trailer Net Selling…
Hi, I have created an enterprise space in Birst available through our CloudSuite License. In this space, I'm using the Infor data Lake connection and have created scripted sources from the LN table data objects in the default schema. After doing an initial load in LN , from Tools→Integration Tools→ Data Publishing…
This is the BQL code of fiscal month i am using getpromptvalue to filter fiscal month based on fiscal year but unable to get the desired result. I have also tried using getpromptfilter to filter but unable to get get desired result.
We have a report in Birst that we would like to be able to obtain the data and use it in another application. This is after modelling has been applied in Birst, so we can't use the data before it comes into Birst. I am seeing several different ways that this should be possible in the documentation for Birst, but I'm not…
I know the functionality to freeze header and/or colums is not available in Designer but I would love to know if anyone out there in the Birst Universe has found a workaround, other than create the report in Visualizer. I have a report with multiple headers so need to use Designer, but that same report also has multiple…
I would like to use the hyperlink functionality for a label in Designer to link to another dashboard in the same space in HR Talent Analytics. Is this possible and if so, since it needs to go through Mingle, what is the syntax?
I am trying to use the result from the IIF() function in the Where clause but Birst simply says Unable to apply filter to measure when I try to do so. My IIF Function has multiple nested IIFs. Even if I try to save it as a Global Attribute, it still doesn't let me put it in the where clause. [AGG_FACT_HH_SNAPSHOT_DATE: #…
It looks like you're new here. Sign in or register to get started.