When opening a standard report in BIRST/Designer, the message "The required session variable is unavailable" is displayed. What should be done?
There are sporadic mentions of PARTITION BY used in ETL Services Input Queries, right after the ORDER BY statement. I have been unable to figure out what that exactly does. There is a snippet of documentation at: By browsing through the old communities, I found a couple of mentions, most notably this one: All of this is…
How can I restrict access so that users only have a subset of fields to work with in visualizer? When I remove the default subject area, they can still type in the search bar to get to anything inside of it. For reference, my setup is a single source space, single conformed dimension space, several model spaces, and single…
I am getting requests from users for what amounts to concatenating varchar data from different rows in the same table. The best example is tracking; a sales order can ship out in multiple boxes that have different tracking numbers. So I have a table with a list of tracking numbers that corresponds to the sales order…
Hi All, I have a scenario where I need to find the start and end dates of Quarter. How to calculate Quater Start and End Date from Time Dimension using script? I found a post regarding this, but I couldn't get the answer. I would really appreciate if someone could help me with this. Thank You in advance!
I have two datasets, let's call them 1 and 2, and I want to layer them on top of each other. Typically I do this by ensuring they have the same grain and are writing to the same fact table, and then load them incrementally in different processing groups. In my current scenario however, dataset 1 can grain to a/b/c, and…
In Space Management → Space Properties there is an option "Processing Time Zone". If you try to change it, you get this info: "The Space Properties Time Zone is used to populate LoadDate and is also referenced for NOW() and NOWDATE() functions." What I need is exactly to tune NOW and NOWDATE to the required Time Zone…
Hello We have a need within our company to make price simulations, or “What -if” analyses. Our aim is to simulate list price with different percentage increases. I have read the documentation about “Getpromptvalue” and there they make examples of making a parameter filter that you refer to in a KPI or report by using the…
Good morning, New to Birst so trying to learn it's syntax and rules. I have a table that I want to show one row per WC Department (screenshot below). The field that is causing the table to split into multiple rows is the "Jobs Idle Over 1 Day" expression. Here is my formula for the Jobs Idle Over 1 day…
Good afternoon, I am new to birst and trying to learn BQL expressions. I have a table setup and each column is a different expression. One of my expressions needs to count the the number of job orders that occurred yesterday, but does not include Saturday or Sundays. Here is my expression listed below, but I am getting…
It looks like you're new here. Sign in or register to get started.