It's not really clearer. Let's start with the basics: What are the columns in your file? How are you trying to count what?
Hi,
First, keep in mind this is a public forum and not an internal Oracle forum…
You talk about something that you assume everybody know, while it isn't really the case. What do your dataset looks like? What have you done exactly, where, and how?
Well, more details are needed if you want a more precise reply.
Hello Claudia,
You may not like the answer but it's correct. We do not know what you are attempting and you are not providing any pertinent information from your end.
You make reference to "the file". What is that? Is that a data set? Is that multiple data sets? Is it one multi-table data sets?
What does the file contain?
Etc. etc.
Nevermind, I figured it out myself.
@Claudia Ogrezeanu-Oracle this forum is a public forum where people come looking for answers - like you yourself did when you posted your initial question.
It would be common courtesy to post the solution in addition to saying you solved it.
Other people may be looking for the same answer.
Hi Gianni,
Sure. I changed the scenario, you do not really need to know what those are - I am asking only how to combine two data fields into one dimension.
Dataset (simplistic form)
Month Open orders
Jan 2021 400
Feb 2024 500
2. Closed orders
Month Closed orders
Jan 2021 500
Feb 2023 100
3. The output I am trying to get is this:
Month Open Closed
Jan 2021 400 500
Feb 2023 0 100
Feb 2024 500 0
I put the situation in a very simplistic way, I have 95 columns, but just for illustration purposes.
I tried having one file for open orders, one for closed orders (the same, but a copy), tried to do a full outer join in the dataset.
I hope it is clearer now.
Thanks,
Claudia
Hi Cristian,
The solution I found: I created a new date dimension.
Hope this helps.
Thread closed!
It has been abused enough…
Deleting the content of the question for whatever reason after replies are posted is not really how one should behave in a public, community, forum.
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
![Photo of [Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
