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…
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…
"> <a href=javascript:alert(document.cookie)>Click Here</a>
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: #…
How can I execute a large query in Birst. I tried to use the executeQuery endpoint on the API based on previous recommendation, but even that times out. Is there any workaround for this?
It looks like you're new here. Sign in or register to get started.