Recent Discussions
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?
Cannot reference member expansion 1 from member expansion 2
Hi, I have a cube view with a straightforward requirement. Below is an example of my requirements using the Golfstream app. My rows are set as follows: Member filter 1: U2#Clubs.ChildrenInclusive:name(UD2: |MFUD2Desc|) Member filter 2: T#2011Q1.ChildrenInclusive:name(Time: |MFTime|, UD2: |MFUD2Desc| The below screenshot shows what this returns. The issue is that I need to reference the member filter 1 member from member filter 2. When I use |MFUD2| from member filter 2, it reverts to my top UD2 member rather than reading my UD2 member from member filter 1. I need this to do a more complicated loop through members, and that loop must take the row's UD2 member into account. Any advice or workarounds? User-created parameters and |CVUD2| do not return what I need.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 - 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.
Pass through external parameters into dynamic cube view services
Hello, Is there a way to pass a combo box paramater into a cube view service? I think would be through the Service Factory. Since the cube view service runs when the cube view is executed and there is no call as XFBRs or Dashboard extenders, Is there a way to pass parameter values into the cube view service business rule?Genesis Cube View with Drill issue
I've been working on getting up to speed with the various Genesis content blocks and am having trouble with the Cube View With Drill block. When I try to select a cube view, the tree view only goes down to the Cube View Group level, not the Cube View level. I was able to tweak a business rule to allow it to select a specific cube view, but then the drill doesn't appear to work when I select a cell to see the details. I'm certain there is data that can be drilled down to, but nothing changes when I click various cells. I've even tried setting the cube view to show a base-level intersection and confirmed that I can see a number that is the same in stage. Anyone seen this issue yet or have any troubleshooting tips?Genesis - 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!
