I developed a report and in the filter I need to use a variable, however, this variable must be loaded with the whseid of the logged in facility. How do I create this variable?
Hello everyone, I have a requirement where there are three company environments, all of which are cloud multi-tenant environments. Is it possible to connect to Birst and extract tables from all of these cloud multi-tenant environments, then perform consolidated modeling and develop a report? If so, could you please outline…
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…
It looks like you're new here. Sign in or register to get started.