05-03-2022
01:39 PM
- last edited on
05-23-2023
03:41 AM
by
JackLacava
I had multiple, fully functioning quick views in my excel file. Once I saved my excel file and reopened, OneStream no longer recognizes two of the quick views. The name manager in excel still has the values associated but OneStream is not recognizing the ranges.
Has anyone else had trouble with this? Is there a way to quickly restore a complex cube view without starting from scratch?
Thanks,
Sean
05-04-2022 09:33 AM
Hi Sean,
When you say OS isn't recognizing them, did they just disappear? When that happens to me, it's usually because I have suppression set or someone sends me a QV referencing POV and we have different dimensions selected. If that's the case (and you're not getting some other explicit error), try setting all suppression to false in the QV preferences (the gear button in the context pane). To get to the QVs, log into OS with the ribbon then use the drop down on the context pane to get to the QVs. Hopefully that helps.
-Nicole
05-04-2022 09:57 AM
Hey Nicole,
Thanks for the response. However, it's not suppression in this specific case. Rather, I'm unable to select the QV from the drop down on the context pane. The QV was in the drop down prior to saving and closing the file, but is no longer being displayed when I access the file now. The excel name manager still contains the ranges that OS initially created, but I'm unable to access the QV - it appears to no longer recognize it from a OS standpoint. See below. The "FXchk" QV is not accessible in the context drop down.
05-05-2022 02:45 PM
Hi Sean,
When you go to the Consol tab and that range in the file, what do you see?
-Nicole
05-05-2022 02:51 PM
For the lack of a better term, "the skeleton" of the old quick view. Everything looks like a QV, ranges/headers are all in tact. However, nothing points to it still being a QV - its not in Context Pane drop down.
05-09-2022 03:55 PM
That is extremely odd. Have you submitted the issue to OS support yet? If you click "refresh sheet" on the OS ribbon, does that trigger the connection? I've never seen this issue before so unfortunately I don't have many suggestions but would definitely encourage you to reach out to OS support if you haven't already.
10-27-2022 11:23 AM
Hi Sean,
By chance, have you found more information on what might cause this? I am receiving reports of users experiencing something similar.
10-27-2022 12:04 PM
No resolution yet, but we did engage OS support and they are aware of the issue (we were able to recreate for them).
01-03-2023 05:02 AM
Hi Sean,
I am facing a similar problem: I have an excel file with multiple quick views in different tabs. Then, I have a tab with all journals (excel journal template) referencing some of the quick views. I have defined all journal areas with Name Manager.
After loading journals to OS, if I reopen the file I can see that all my quick views are not recognized by OS. I mean: I am connected to OS but I can't refresh any quick view of that file. However, I can create a new quick view.
It is frustrating because after I load journals I lose my quick view configuration...
03-22-2023 11:54 AM
Hi,
Did you receive any feedback from OneStream to resolve your issue? I have a similar problem and would like to know the resolution to this issue.
Thanks
03-22-2023 11:58 AM
Hello,
I haven't seen anything directly (not our company's admin), but I'm hopefully that this has been resolved in the latest 7.4 Release per the note below.
03-22-2023 12:05 PM
Hi,
I resolved the problem by my own. In my case, I realized I was making a mistake in the Name Manager. Before defining all journal areas, I deleted all references in Name Manager, and therefore I was deleting my quick view connections!
Don't know if you are making the same mistake, but I hope it will help you.
03-22-2023 12:11 PM
Hi ,
I looked at Name Manager, noticed that user is using QuickView1, but when I looked at the Quick View, I cannot fine the QuickView1.
It is very puzzle in this scenario.
10-19-2023 05:27 PM
We're on 7.4 and having the same issue with multiple users. User creates a QV on a new sheet, saves it, and when re-opens/logs into the file later, sometimes the QV is not active anymore, i.e. the formatting and the data is there hardcoded, the named ranges are also intact, but when you click on the QV, the Context Pane does not get activated, basically the QV is gone.
The problem is, the issue happens intermittently, so if we open a ticket with OneStream, we wouldn't be able to replicate it on a call.
11-14-2023 07:26 AM
Hi there,
We are also having a similar issue to what has been raised above. User creates multiple QVs on multiple tabs and when re-opens/logs into the file later the QV is not active/hard coded. We have the same issue as user @tugsan .
@tugsan did you have any resolution on this? We have raised a ticket with our Implementation Partners but will also raise with OneStream.
Thank you!
11-14-2023 11:47 AM
@Sophie_Downie unfortunately, not. Since we are not able to recreate the issue at will, we were not able to show it to the OneStream support. Our users still have this issue happening. We haven't found any pattern or solution.
11-14-2023 12:13 PM
Hi @tugsan, thank you for the fast reply on this one, noted. We will still raise a OneStream ticket and report back the progress.
02-21-2024 01:01 PM
Hi! Did you happen to get a resolution for this? Experiencing this as well.
02-22-2024 04:16 AM
Hi! No we didn't, we are about to upgrade to V8 though so will monitor if this impacts anything, we also thought it might be to do with some of the users who are accessing the files are not OneStream users and it breaks by the time the users re-access.
07-04-2024 10:53 AM
Hi! We are now experiencing this issue. When we re-open an excel file which had a live QuickView, everything is hardcoded. Does anyone have a solution? Thanks!