That works for me. Thank you very much for your help. Best regards, Kauan Bohn

Unfortunately, the error indicates a missing right parenthesis ORA-00907: missing right parenthesis WHERE xah.application_id = 707 AND xal.application_id = 707 and ccd.cost_book_id = '300000082235861' AND ccov.cost_org_name IN (:P_FILIAL) AND gcc.segment4 IN (:P_CONTA) AND xah.period_name IN (:P_PERIODO) AND (…

That answer my question: SELECT bu, INVOICE, DATE_INVOICE, VALUE_INVOICE, DATE_ACCOUNTING, amt, prepay_amount_remaining, description FROM (SELECT hou.name bu, ai.INVOICE_NUM INVOICE, TO_CHAR(ai.INVOICE_DATE, 'DD/MM/YYYY') DATE_INVOICE, TO_CHAR(AIL.accounting_date, 'DD/MM/YYYY') DATA_ACCOUNTING, ai.INVOICE_AMOUNT…

This shows how much AI can improve our lives outside the internet. Great!

That's really interesting

It's amazing to see so many ideas and talents together with all the professionals in the community

Hello, of course. This is the screenshot of the cell formatting: And this is the result in my pivot table, correctly formatted (OP Field):

Hello, in case it helps someone, I found a way to keep the leading zeros while keeping the field as text. I selected the cell properties and set the format to CEP Code (Brazilian Postal Code). In this specific case, it worked for my issue and allowed me to proceed with the pivot table. Thanks

Thank you for the quick response! And is there any other solution to preserve the leading zeros using the text type? Even with this, I encountered this limitation. The only solution I found was to concatenate a blank space in front.

It remains a relevant topic.

I tried this way in a subselect, and it worked: SELECT hl.city FROM HZ_LOCATIONS hl WHERE hl.location_id = jfdla.FINAL_DISCHARGE_LOCATION_id) Thanks for the help!

Hi, It helped me identify that what I need is to find the description of SHIP_TO_LOCATION_ID, but I couldn't find the table that can be joined with JG_FSCL_DOC_LINES_ALL to bring me the description. I tried the following query: SELECT jdfla.SHIP_TO_LOCATION_ID, hl.city FROM JG_FSCL_DOC_LINES_ALL jdfla, HZ_LOCATIONS hl…

Check this: What i have to do to link this 2 queries in data set?

Sure, I will attach it. But it doesn't work for me

Yes, that's right, when running a query in isolation it returns values. I thought of an alternative path. I tried to do this through the data model, linking the FK of hou.name || rcta.attribute15 with Query 2, but I am unable to establish this connection, even though it is the same.

I have this information on ra_customer_trx_all, but when i link them, it's no data found. 

Great! This interaction between the community is really cool.

I have tried this, but it's difficult to find a FK in OTBI side. I'm thinking if that is the best way to execute, or if i should do it by query

I found it, hope that help someone else: TABLE.COLUMN: rbsa.name nome_origem JOIN: rcta.batch_source_seq_id = rbsa.batch_source_seq_id

Excited to learn more about Accelerated Dashboard Creation