I was running into the same problem. The way we are solving for this is to stop using excel spreadsheets for data storage. We configured our APEX and moved all the data to interactive tables. Then, as soon as the data is updated, it's stored in the database. Then all you need to do is refresh your report page and your data…

Here is an example of OAC DV on top and APEX on the bottom. The OAC graph takes about 10 seconds to load versus the APEX graph takes less than 1 second. I should get the option to "load quickly" or something like that on the OAC side so it can load approximately as fast as APEX.

Can't we just add another option in the Relative To field that includes "End of Current Period"? With that being said, you could add others such as: Today End of Last Period End of Current Period End of Next Period

In case you haven't seen it yet, there are more options now, but there is only one other option. I will be submitting another idea to expand it.

This would look sharp. I like this idea.

@Bret Grinslade - Oracle Analytics-Oracle Yes, a save temporary dataset at this point would be good. Sample data would NOT be enough for me. I would be ok with being able to insert a save step and then being able to continue on beyond that step. Right now, as soon as you put a save step in, you can't do anything past that.…

In addition to being able to cache the entire data flow, we should be able to be in the middle of a data flow and have the option to run it to a certain step in the flow. If you have 10 steps in the flow and I worked on step 5, I want to run it to step 5, be able to check the data, then proceed with step 6. Then as I'm…

Related Idea.

Agreed. I'll be entering a separate idea.

I came on here to put in this idea. I also would like to look at this the other direction. I would like to more easily add OAC catalog objects into APEX. That would allow me to create my dashboards using APEX and then I could embed the OAC workbooks into the application. That would allow me the option to combine multiple…

Thanks Bret. I have several examples. I started a conversation with Gabrielle. Let me know how I can best help out.

To your comment about the renaming or aliasing in the subject area, you are correct that the queries will keep working….in the reports. The datasets, on the other hand, do not keep working. That's what sparked my SR and was told that it's expected behavior.

There is no lineage across Oracle Analytics products. I have several connections that I would like to delete because someone created them by accident not realizing there were already some. Now we have duplicates. I can't delete them because some reports use them but there's no indication which reports. Even if I did find…

@User_S9QDQ that's a very creative idea and appreciate the suggestion. However, hear me out, if you mark something as "Delivered" for everyone to see, maybe it should actually be delivered. I just checked again and it's still not working.

@Marcelo Finkielsztein the brushing, from my perspective, only adds the highlighting from one visualization to another visualization on the same page. You still get the same functionality when you turn on filtering on each viz. When I worked with the CEAL team about poor workbook query performance, their first…

Just get rid of brushing if that is causing the limitation. I turned off brushing by default and no one even mentioned it was missing. People mention that copy/paste is missing every day.

Thanks for all the responses so far! So, if I'm reading this correctly, we think the addition of the Load Messages causes the load time to be worse? As far as the networking piece of it, I'm not sure how that would be a factor. We're already logged in and navigating around OAC loading lots of workbooks. We shouldn't be…

Love this idea!!

I was about to create a new Idea and saw this one. This is exactly what I was going to write. This is something you can do in Answers. It should be added to DV. It adds unnecessary steps to the consumers of the workbooks.

This is not working for me either.