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 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?
Getting the following error response: {"errorCode":"DEV-0400","message":"OAuth key doesn't exist.","params":{}} Any idea what this means? I do have an OAuth key that I generated to get the key/secret pair. I am able to do this with my old commercial tenant, and duplicated what I am doing in postman, just with a new…
I have a table report that I need to export to excel every month or so. It only has a couple thousand rows, but is 45+ columns wide and has lookuprow expressions which make it very heavy. I find that I have to grab an attribute that has several values and filter one at a time doing an export for each (and even then it…
Is there a way to left align text inside a KPI? It defaults to center aligned, which is ideal in most cases, but not this one…
Has anybody else experienced hover pop ups that will not go away? I am seeing them in Visualizer and Dashboards with more and more frequency. I am also seeing pop ups that have nothing to do with the report I am viewing. For example, the below pop up looks like it should be on a bar chart but the report in question was…
Hi there After the LN Analytics update was run at a client, the reports/dashboards no longer have Time dimension drilling available. Even when creating a new Visualizer report, the attribute Year\Month is static and cannot be drilled. Has anyone else experienced same? Is there a resolution on how I can fix this? Thank you…
Hi, I am getting an error "Cannot read properties of null (reading 'indexOf')" when using the STAT() function as my denominator. I even use the IFNULL() and IIF( savedexpression('a') IS NULL, 1, savedexpression('a')) but still getting the same error. Could you help us find a way to avoid this error? Regards, Christian
I am interested in embedding a Birst Dashboard into a Lightning Page. I am able to embed Birst into the Classic Salesforce no problem, but when I try to access it through Lightning, the Server refuses to connect. I am not sure if the rules are different or if Birst does not support Salesforce Lightning.
I have a problem with making filtered KPI expression. The formula below doesn't work. [Recognition Date: # Distinct recognitionHashKey] WHERE [Fiscal Time.Calendar Year] = GetVariable( 'Current Calendar Year' ) AND IIF( 'V{USER_GROUP_LIST}' = 'Admin' OR 'V{USER_GROUP_LIST}' = 'Power User' OR POSITION('V{USER}', [Manager…
It looks like you're new here. Sign in or register to get started.