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.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
![Photo of [Deleted User]](https://us.v-cdn.net/6037859/uploads/defaultavatar/nT2GKTLRQJ3P1.jpg)
