Hi, We use Snowflake as our database with Keypair authentication. I need to connect BIRST to Snowflake but am unsure how to configure Keypair authentication within BIRST. Has anyone encountered a similar situation or can offer advice? Here is what I have attempted so far: Selected Database type as "Other" and SQL type as…
I am receiving an 'Index 0 out of bounds for length 0' when using a double lookup. I am guessing there is some data missing in the lookup keys, but I am not sure how to account for that (?). LOOKUPVALUE(0,LOOKUPVALUE(0,[WFM-EmployeeBalanceLog.GHR Employee ID],1,SELECT [Work Assignment.Employee Key],[Work Assignment.HR…
Does anyone have a good formula for a pareto chart in Birst? This is often requested and we always have to take it to excel to be created. Before I spin my wheels, I figure someone may have solved this issue before with a formula to create the pareto line on top of a standard column chart.
I am currently working as an intern, creating a dashboard for the Procurement department. There was already an existing dashboard, but it was incomplete. I am now trying to add more information to the data source, but I have been unsuccessful so far. Specifically, I am attempting to add the table "ln_whnwd210" to the…
Birst Agents rely on Java JDK in the Amazon Corretto release. Agents are updated from within Birst, but there appears to be no automatic way to update Amazon Corretto and I have found no info around over the web. Does anybody have any specific advice on how to manage this topic? I want to specify here that I have Amazon…
Is there a 'paste values' or something equivalent in Designer? I have a calculated column in the detail band that gives a count based on a percentage, but since you cannot sum percentages - or do any aggregations with percentages - I am at a loss as to how to show just the sum of the count in the footer. For example, the…
Hi there Hope you are well. I am having some issues with the GL dashboards in LN Analytics. Everything has been configured. all the different Modules Dashboards are working and shows data, however the GL set of Dashboards, the data keeps disappearing. The GL Dashboard works perfectly fine one day, and then the next day…
We are moving from M3 On-premise to M3 Multitenant Cloud and will be using BIRST for much of our reporting. Some of our reports will be bursted by a value and emailed to users. This requires a data source to contain the email addresses and the burst value. This is to be uploaded to the BIRST environment. We don't have the…
I have drillbacks to LN working from LN Analytics. I was now trying to do the same in a new Birst Space, but they don't work. I tried opening the LN Analytics Consumer Space from Birst instead than by the LN Analytics app, and the drillbacks don't work this way. Why? (Note that I go to both Birst and LN Analytics from the…
How does Sum work in Prepare scripts? I have tried a join and a sub-select without success. :( My end goal is to use one script to get different balances on one row - Beginning Balance (everything before a particular month), Current Activity (everything in the month), and Ending Balance (Beginning Balance + Current…
It looks like you're new here. Sign in or register to get started.