Hello Nathan. Very good morning, I am attaching in a spreadsheet the results of my query. Within the file project C001599 return 2 rows from Oct-24 to Nov-24. Project T002220 returns 7 rows from Nov-24 to May-25. Project T002221 returns 7 rows from Nov-24 to May-25. Project T002224 returns 3 rows from Nov-24 to Jan-25 and…

Hello dear experts, I am looking for some help with this pivot RTF template, I am almost done with my template however I am not able to figure out the error I am getting, in below screenshot I have colored in yellow two projects, T002220 and T002221, for this couple of projects amounts should be displayed from Nov-24 to…

Thanks so much Nathan, that helped a lot.

Thanks Nathan, thanks for the clarification it helps, I have tried with all the examples in the answers through this post, however I am getting below error now: java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 13076] User 'XXX' doesn't have the access to this connection…

Hello, doing a simple BIP data model trying to query a PVO is not working in my case, below query: Select_physical t.* FROM "oracle.apps.scm.productModel.items.publicView.ItemEffPVO" t It returns the error: Nonexistent table: "oracle.apps.scm.productModel.items.publicView.ItemEffPVO". Even I tried the same query with…