I've tried using REPLACEALL and am not having much luck as I do with other characters. Does anyone know how I can clear a string containing these characters " \
I have the following in a SELECT - SELECT [Level(Employee.Employee).Employee Key], [Level(Employee.Employee).Termination Date] FROM [Level(Employee.Employee)] LEFT OUTER JOIN SELECT [Level(Employee Work Assignment Actions.Employee Work Assignment Actions).Reason Code] FROM [Level(Employee Work Assignment Actions.Employee…
I have a scripted source (e.g. fact_update) that will update the fact table (e.g. fact_table) with multiple column keys and dates (analysed by date). I only need to update the measure deleted_flag to 1 (for some records) and then another scripted spurce (e.g. delete_record) to execute the DELETE FROM. Given that these…
Is there a good way to add/subtract quarters from the current date? For example, sales 1 quarter ago, sales this quarter, sales next quarter, etc.. I noticed that you can't use Quarter Seq Number in the date functions.
Is there a way to identify the BIRST spaces that are using SQL queries, or SQL credentials? We need to replace the SQL credential in the spaces, and the BIRST account we are using is tied with hundreds of BIRST spaces. For example, find the BIRST spaces that have extraction SQL query below: SELECT address_id, addressname,…
With an excel input, I wanted to validate that the values are numeric, and in the case where the user has a string, error, or blank in the cell I want to cast it as something else. I tried the IsNaN function but it didn't work as I expected. I did IsNaN('test') and it returns false, so that doesn't really help me. Any…
Just created Enhancement Request 116631 as per object: Please consider endorsing. Thank you! Enrico
Hi, I'm starting to learn Birst so please be understanding :) I'm trying to make relationship between tables MWQIRS and MPDIID through field INSI and it doesn't work. Scripts are just to narrow results to specific CONO and FACI. What possibly am I doing wrong? Thanks in advance for the tips. Marek
Hi, I need to add a new derived field as an additional analyze by date. What is the best approach for data already in the fact table? Do I read the fact table, derive the new field, right out with same grain with the analyze by? There is a very large number of records in the DL, so i do not want to have to truncate and…
Hello, I have a dashboard that has a between date filter. The report has subtotals by date, division, warehouse, stock transaction type. With the subtotal options, am i able to set up a drill across that passes to another report the one date? What if i want to have the item, stock trans, warehouse, division, and date…
It looks like you're new here. Sign in or register to get started.