Replies posted by ola.nissen

23 Replies

ronhuHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

SQL Information Source Data

@ronhu Have you tried: select * from FACT_INVENT_TRANS_HIST_DM That would work!

2 years ago

ronhuHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

SQL Information Source Data

Yes. An information source is “no more” than a view, from a database perspective. So you can query for it with SQL to validate it. Make sure to be logged in with the same user as the one that you are logged in as when running through BR - it could potentially be that there is row level security set up, meaning that the user don’t see the data although it’s there in the database.

2 years ago

SteveMDo Gooder (Customer)

asked in Alliance

Alliance Export Template Wizard - missing components

@Yasas Kasthuriarachchi - could you move this to https://community.ifs.com/groups/alliance-265?

2 years ago

SteveMDo Gooder (Customer)

asked in Alliance

Why does reporting sometimes show all fields and others not?

@Yasas Kasthuriarachchi - could you move this to https://community.ifs.com/groups/alliance-265?

2 years ago

LinkSuperhero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Generate a Rowkey while inserting a row

@Yasas Kasthuriarachchi - can you please move this topic to Framework & Experience.

2 years ago

LinkSuperhero (Customer)

asked in Projects Based (Contract/Resource Management, Project Management, Engineering Design & Deliverables)

Add custom fields in Project Navigator

@Yasas Kasthuriarachchi , please move this to the section [Projects Based ...].

2 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby drop down menu?

No, similar concept is available in Apps 10 as well.

2 years ago

cperdueHero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Pay Method

Well, that just looks like a pipe separated file, instead of “comma separated values” (csv). So if you have the data in a form, you should be able to export that to the desired format with my suggestion. Good luck!

2 years ago

cperdueHero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Pay Method

Not sure what you mean with “mixed output”?But if you want to export data from the forms directly, you can always set up an output channel using the pipe character as delimiter?

2 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Lobby drop down menu?

Hi,the use of parameters in Lobby elements are described in the Technical Documentation for IFS Cloud.https://docs.ifs.com/techdocs/21r2/060_tailoring/220_configuration/100_lobby_configurations/020_page/I hope this helps.

2 years ago

VIMNLKDo Gooder (Customer)

asked in Supply Chain

How to get a report including the list of customers that we send an invoices via e-mail? (E-invoice via email but non EDI)

@Yasas Kasthuriarachchi, please move this thread to the Supply Chain group.

2 years ago

ProThushADo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

What BI Reports are Available for Manufacturing

Hi Thushan, long time no hear!I assume that you are talking about our offering in IFS Cloud?You can find what we have in terms of Analysis Models here, in the documentation for IFS Cloud - https://docs.ifs.com/ifsclouddocs/DocBusinessIntelligence/IfsAnalysisModels/AboutAnalysisModels.htmRight now this seems not to be updated for 21R2 (released last Friday), since there should be three additional models in addition to the one listed (General Ledger, Group Consolidation and Maintenance). Regarding Manufacturing, the intention is to deliver it with the 22R1 release coming spring. Together with each analysis models we release, there is also a matching example Power BI dashboard that can be provided showing some examples of analysis done on the data from the model.

2 years ago

sholmesHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Apps9 printing error

Hmm… My (outdated?) technical knowledge tells me that these kind of error messages usually happens once you run and try to use the PL/SQL package (like "IFSAPP.PART_SERIAL_CATALOG_API") the first time after there has been some deployment of code in the database. Usually after a code delivery, the deployment process should contain a “re-compile” step so that all packages gets recompiled and refreshed. But I can also see that there seems to be something regarding global variables etc. in this thread - https://stackoverflow.com/questions/1761595/frequent-error-in-oracle-ora-04068-existing-state-of-packages-has-been-discardeDoes it usually happens after an update of the code to your system? Say after weekends or in the mornings?

2 years ago

hhy38Hero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Bizapi Development - Cannot Find Required Model

@Yasas Kasthuriarachchi, please move this to the Technology (Infrastructure, Cloud, Integration, Dev Tools) section instead. He will have better luck finding someone that can answer his problem there since it relates to development (tools).

2 years ago

RutJWhalenSuperhero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

When a user runs a Business Reporter report via Order Reports not data is being displayed

Can there be a row level security on the objects that you are selecting from? Something not allowing that person to see the data. Or maybe they are not connected properly to company, or site, or some other configuration to give them access.Which views are you trying to select from?

2 years ago

ZTC ZTC JGOTAHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Quick Report Error when an IFS USER Log in with another language

My guess is that this is caused by either a faulty or missing translation. Given that it happens when not using English. Have you tested it with another language as well (if you have more)?I think that you should register it as a bug so that support can look into it properly.

2 years ago

AIDA LOTFIDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

EOI

We will provide support for critical corrections and security concerns, but there is no further development of the product done nor will we correct bugs for which there are workarounds.Currently work is being done to include similar functionality in IFS Cloud, even if it most likely will be some time those capabilities match what you can do today with the IFS EOI solution.regardsOla

3 years ago

BZNSIMONSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

SQL weeknumber issue: wrong weeknumber

Hi @ola.nissen , Thank you for your reply. … Do you know what I am doing wrong? I expected the statement to return weeknumber 12 for all the dates above. Sorry, I’m out of ideas now.As to the comment from EntNadeeL I based my substr on the data that you showed, where you month number was a one digit number. Ideally the data that you have (as strings?) should be formatted in the same style so a consistent approach to string-handling can be applied. If you have strings like “1-1-2021 0:00” and “31-12-2021 10:10” it will be harder to write functions to handle those strings.

3 years ago

BZNSIMONSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

SQL weeknumber issue: wrong weeknumber

You have a date where the month is only represented by a single digit, while in your date mask you have MM indicating that you expect two digits. Can this be the problem?Edit: Did a quick test actually running your statement, and I see two problems. First, your date mask doesn’t account for the time portion of your value (I assume that 22-03-2021 0:00 is your text string in your data). When running that statement in SQL Fiddle I get the following errorSELECT to_char(to_date('22-3-2021 0:00', 'DD-MM-YYYY'), 'iw') FROM dual;ORA-01830: date format picture ends before converting entire input string If I change to include the time portion, I get the following errorSELECT to_char(to_date('22-3-2021 0:00', 'DD-MM-YYYY HH:MI'), 'iw') FROM dualORA-01849: hour must be between 1 and 12 If I change to SELECT to_char(to_date(substr('22-3-2021 0:00',1,9), 'DD-MM-YYYY'), 'iw') FROM dualremoving the time portion in the input to to_date, and using iw (internal week) I get the correct result for the dat

3 years ago

hazelmsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Basic data change log

@Yasas_AK - can you please move this to the Technology subforum. Thx.

3 years ago

hwilkieDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Analytics - Invalid Number error

Sorry, I don’t know whether that’s possible. If you, as the original poster, don’t see a choice like “Move...” I think it would take someone with a lot more grants than me to do it if it’s at all possible, but I think that quickest way would be just to copy/paste the question into the other community.

3 years ago

hwilkieDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Analytics - Invalid Number error

The Information Sources are owned and maintained by the groups owning that area. We in Insights only make use of what they present. You would have a better chance of getting an answer and hopefully resolution to this if you ask this question in the Selling community (I believe it to be Selling, at least - perhaps you know better or can confirm).Good luckOla

3 years ago

cjohnsonSuperhero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Material usage by Work Center

I think that you would have greater success in getting a good answer by posting this in the Products (Manufacturing, ...)-community. While the Insights solutions might be displaying the information in a nice way and allow you to explore the data, the data still comes from the product groups responsible for it and they are the ones that are publishing/making public the data that Insights show.Good luck!

3 years ago

Replies posted by ola.nissen

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded