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: https://mingle-portal.us2.prd3.inforcloudsuite.com/v2/CONCIERGE_PRD/?LogicalId=lid://infor.cxp.1&Tab=ERS&ERId=116631 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…
I have a columndiagram and I want the segment values to display percentages instead of what it is now. The percentages only show when hovering over the value. Is there a way without changing the measures to achieve this?
Consider the following: Source A LEFT OUTER JOIN Source B ORDER BY FieldFromA, FieldFromB If I do this, it won't effectively do the left outer join as it needs the column from source B. Is there a way to only order by the second criteria if it's not null?
Figure I'd ask before I spin my wheels on this. Normally I'd think to order all of the rows by the global, parent, component to build out some BOM path strings, but LN doesn't have a global - everything is just parent and component. My first thought is I could fake a recursion by joining to a bunch of copies of the same…
It looks like you're new here. Sign in or register to get started.