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…
When designing or personalizing reports, I use Report Designer. I cannot transform the layout of the data visible in the rows - SELECT ABCDE001.VALUE1, ABCDE001.VALUE2 FROM ABCDE001 VALUE1 VALUE2 10 100 55 550 24 240 On the arrangement of data in columns (pivot) VALUE1 10 55 24 VALUE2 100 550 240 How to make such a…
It looks like you're new here. Sign in or register to get started.