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…
Is there a reason that an expression like this would work fine if manually put into a number of reports, but not if saved as a global expression and put into the report as a saved expression? [Invoice Date: Sum: Sales <EVAL!GetPromptValue('Reporting Currency','USD')!>] I'm doing this to allow users to choose a reporting…
Why are my account group permissions in the catalog (where you set permissions on folders with dashboards and reports) being wiped out by copyspace? My command looks something like this: copyspace fromspaceid tospaceid…
There have been changes in 2025.02 for copyspace and duplicate space (from the global navigation bar + menu). Please take a look at the KB3569756 article in ServiceNow for important information about data movement. *if there are issues with the link, open ServiceNow through Infor Portal/Concierge and search for the article.
I have two measures, [Delivery Date: Sum: Releases Delivered] and [Delivery Date: Sum: Releases Delivered On Time]. Each gets set to a value of 1 or 0 depending on the order release status. I'm trying to do a basic on time delivery calculation, but it keeps returning the number of releases delivered instead of the…
It looks like you're new here. Sign in or register to get started.