Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I haven't seen this problem before. Can you create a simple repro with an excel sample file and share a screen shot?
-
JDBC support is on the roadmap. The next OAS update will be in early 2025.
-
Is there a reason this can't added to either the data source or a 2nd dataset that you blend on the data tab? The parameters feature is not intended as a source of data but more as a tool to help you create experiences in the workbook.
-
@Teemu Jutila You can paste in formatting in to the Text viz. Is that what you are referring too? If not, can you explain in more detail or post an example of the kind and source of the formatting you are looking for?
-
What does the Cumulative count mean hear — year to date? For example if you pick may and have data from Dec 2021 — should that be in the amount?
-
You can also implement data level filter with roles in datasets.
-
I think this is a duplicate of the following. Can you confirm?
-
There are few ideas in this topic. The main one seems to be "a common homepage" which is being planned.
-
What does the calculation your are looking to do mean in general terms. For example if you have: Week Date ID Planned Week Number 7/28/2024 A 0 31 7/29/2024 A 1 31 7/30/2024 A 1 31 8/8/2024 A 1 32 8/9/2024 A 9 32 For Week 31 -- do you want 1 as the answer? For Week 32 -- do you want 10?
-
@Rajakumar Burra — it is not clear why you need to add all the datasets here. One note is that when a dataset is in a workbook — the workbook assumes all the columns can be used together. So you are both managing datasets and also defining where joins work. It might be worth a call to learn more. Since the dataset is…
-
@User_FBG8L this seems like a related but useful idea — allow a step (perhaps at the add data stage ) in a data flow which allow experessing a manual sql. Can you create a new idea entry so it gets its own votes?
-
What is the scenario here? Today the data flow generates a query (such as where mycolunm > "last updated time" ) What would you want to happen for an alpha numeric column?
-
This looks to be posted in the incorrect area. Is this an analytics question?
-
I think this is posted in the wrong area — this is the analytics idea lab. Is this an analytics question or a PPM question?
-
Can you confirm you are looking for workbook style search on the dataset Edit Definition page?
-
@MGibbs_2023 — if this were an option in the dataset editor — is that sufficient? @Luis E. Rivas -Oracle This seems useful.
-
The improvement is on the roadmap. We don't have a target release date yet.
-
The enter manual SQL option in OAC doesn't support all SQL syntax. I would expect it to give you and error and not allow you to save the definition. If you have database access, implementing a view is a good work around and they you will do a pretty simple select in OAC. And Idea Lab suggestion on support either JSON…
-
Can you elaborate on Map to Table? You can switch viz type from map to table today. What is missing?
-
This is a useful improvement. A few things available today — you can use APIs to do backup/restore of snapshots. You can also look at the fullstack DR offering.