Genesis - User action to refresh another cv basic
Hi, I am trying to create a genesis dashboard that will have a main cv (1105) which shows overview and then when user click on the cell, it will filter another cv (1106) (probably cv basic since it will have navlinks on most dimensions). In client dashboard, it requires the config of setting of user actions in 1105 cv component but I could not find this setting in content block CV Advanced. I can find it in CV adv embedded. I assume this is the correct content block to use. I managed to get this function to work when 1105 and 1106 are on different pages. This means the cv are both setup correctly with navigation links dynamically set up correct. But they cannot be in different pages in Genesis because that means user need to click on cell in 1105 in page 1 and then go to page 2 to see filter results in 1106. That is too much work for user. , Thus, I created a dashboard advanced layout and try to insert cv advanced embedded of 1105 in row 1 and then cv basic of 1106 in row 2. for user action in 1105, it is very difficult to select the right component to refresh. I chose the name that is closest to the genesis given name for the basic cv 1106. but this did not work. When I clicked on the cell in 1105 in row 1, nothing changes in 1106 that is in row 2. See below. What is wrong? The list of "component" in the dashboard selector is sooo long. I trial and error a few and some seem to be just a filter selection page in a content block created. Is there any documentation that will explain which one or type to choose? I checked the user documentation for cv advanced embedded and it does not mention much.Genesis when in client - Taskbar excel etc
Below is a screenshot of how the genesis dashboard look like when it is used inside the client. The report on the left is the source cv and report on the right is the drill down details when a cell is clicked on the left. You can see that there is no taskbar for excel download etc in the left report, even though I have set cv default header to be visible. Both the left and right reports, I am using cv advanced embedded, but the left one is the one with user action "refresh" with click. I used the source cv of the left report as content cv with comments in another page and there is taskbar for excel download. The only difference between the two of them is content block type and user action. I checked the user guide for cv with advanced embedded, there is nothing written that when user action is selected, the taskbar for excel download etc will be gone within client. How do I get the taskbar for excel etc to appear when using genesis within the client?
Dynamically changing a Cube view row to allow Input
I have a requirement to allow users to enter an Annual Plan and spread it across Plan Periods using the spread method they select. Spread Methods are Equal Spread, 4-4-5 Weekly Spread and Manual. When they select "Manual" the cube view should dynamically pick O#Forms as Origin member for Data Entry. I have the Account and Product in rows with member expansion (.Base). Is there a way to retrieve the Base Account and Product from Cube view dynamically and reference in an XFBR?My plan is to get the Spread method chosen for the Base Account and Product combination and Return the Origin as O# Forms for that row? Please share any other ideas if you may have implemented for the same requirement?
Spreadsheet via Browser dashboard (OnePlace)
Hello everyone, I am currently working on OneStream v9.2 and trying to set up Ad Hoc reporting in the Web version (OnePlace). Context: I created a Dashboard with a Spreadsheet component exposed in Web (under OnePlace Dashboard). The connection to existing, preconfigured Cube Views is working correctly. Issue: In the Browser version, I do not have access to Quick View / dynamic POV features like in the Spreadsheet WinApp (Excel Add-in). I cannot find the option to perform free-form Ad Hoc analysis (changing axes, selecting members dynamically, etc.). Question: Is this a standard limitation of the Web version (OnePlace) in v9.2? Is there a specific configuration that enables a Quick View–like behavior in Web? Thank you in advance for your feedback and experience.Cache dashboard results to improve performance when switching tab?
Hi folks: I am searching for suggestions to improve reporting performance in dashboards. We have a couple of simple, executive dashboards that consist of 5-10 tabs of cube views. These work great for managing a common set of reports for end users. Parameters are managed within the dashboard and persist when switching cube views (tabs); all that works great. However, users complain that it is slow to switch between cube views (tabs). It appears that each cube view is re-run when switching tabs rather than simply displaying the data that was previously refreshed. While most reports take <2 seconds to run, a few can take in the 8-15 second range which is deemed unacceptable. Are there any methods (formal or hacked together) for caching cube view results so that switching tabs simply displays already refreshed data rather than re-running the cube view? Thanks, -db
Data Adapter SQL Query to view data submitted through Excel
I am here with one of my typical requests to see if anyone has (SQL query) code I can borrow 🙂 We had an issue with two users who discovered how to submit data through Excel and circumvent the workflow forms. As a result they are inputting data to intersections where we do not want forecast data. I would like to have a dashboard I can run where I can select a specific scenario and it will return a list of intersections that were modified through an Excel submit. Or just a list of users and then I can run the ONC application report User Data Entry Detail to get the details of the intersections. I know the data lives in a table somewhere but I am not sure the table name and the fields to filter on and return. In the ONC User Data Entry Detail report I am able to select a scenario, WF time and user name and can see data they changed via forms and data that was changed via Excel. But, there is no option to see all Excel edits for all users and I am trying to catch the rule breakers 🤫. Any help with a SQL query would be greatly appreciated so I can create a data adapter, and display it via a grid view in a dashboard. Thank you, DeniseGenesis - CV with comments - red flag on top right
I have created a cv with comments for comments input and review. The comments are saved and viewed with success but I am missing the red flag on the cell where there is comment in the cells. See below. According to feature video for cv with comment, there should be a red flag see below screenshot: What could be the reason it is missing?
Drill-Down to Stage with Attribute Dimension
Hi everyone, I have two attribute dimensions in my model that I use to filter Cost Centers by Region and Line of Business. The issue is that when I try to drill down on those cells to reach the Stage data using “Load Results for Imported Cells”, I’m not able to get to the maximum level of detail. I assume this happens because the system is filtering by attribute members, which do not exist in the Stage tables. Has anyone experienced something similar or found a solution/workaround for this? Thanks in advance!
