Does anyone have a successful connection directly to a google cloud platform cloud SQL database? I believe Birst removed the ability to connect directly to a public IP which has made this more complicated.
Hello We have a small problem in our environment. It is about copy notifications from one space to another. In our development flow we usually make a copy of our PRD space and make the development in the copy. When that is ready, we make a swap between the spaces. The challenge here is that we don’t get all the…
Hi All, I'm trying to calculate category shares for a specific brand. When I filter the report to display a single value in the Item.Brand dimension (values are filtered in the QTY measure) and CAT QTY shows the total category quantities across all brands in rows, the shares are calculated correctly at the row level.…
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…
It looks like you're new here. Sign in or register to get started.