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.23Views0likes1CommentPass 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?17Views0likes0CommentsDrill-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!26Views0likes0CommentsSecurity Report - Dashboard for Admin- Access
Good day to you. Currently, we are working on a Dashboard for User Access. We have successfully implemented the logic to retrieve Security Group Unique IDs along with their corresponding Security Group details. As part of this dashboard, we now need to retrieve Workflow Profile–level details, specifically: Entity assigned to the Workflow Profile Access Group Maintenance Group Workflow Execution Group Certification / Signoff Group So far, we have been able to retrieve details for points (1), (2), and (3). However, we are unable to fetch the Workflow Execution Group and Certification / Signoff Group details using either Business Rules or SQL queries. Could you please help us by suggesting: The appropriate Business Rule method/API, or A supported SQL approach, to retrieve these remaining Workflow Profile security details? Your guidance on the recommended approach would be greatly appreciated.Solved47Views0likes2CommentsEmbedded dynamic repeater
I have a cube view with a parameter on Entity |!Entity_select!| that I would like to put in a tabbed dashboard that has one tab for specific Entity member. I am using dashboard type "Embedded dynamic repeater" where the component is data explorer report. Data explorer report has data adapter component to the Cube View. I thought the way to do this would be to use the template parameter values in the collections. But it shows error as attached below. It seems that the template parameter value was not passed to Entity_select parameter. Is data explorer report component compatible for dashboard embedded dynamic repeater? Is there any sample of Embedded dynamic repeater dashboard using data explorer report component? TIA, Nuryana89Views0likes4CommentsHow to populate a Dashboard List Box referencing WFText4 but the UD dim may vary across Workflows?
As the title suggests, I am trying to populate a dashboard list box that references the Workflow text property regardless of the dimension being used. I'm able to populate the list box using a single dimension, meaning a UD3 member is populated on the workflow's WFText4 property and a member list parameter uses |WFText4| to pull it in. How would I get this to work if the Workflow text value is not always UD3? For Example (both workflows will be using WFText4): Canada Workflow A needs a UD3 Member.Base to populate in the list box when they run the dashboard in their workflow but Canada Workflow B needs a UD6 Member.Base to populate the list box when they run the dashboard in their workflow. Please let me know if I can provide more context.53Views0likes3CommentsNarrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!180Views1like2CommentsReplicating a Cube View in tabbed dashboards
I have a cube view with a parameter on UD5 |!param5!| that I would like to put in a tabbed dashboard that has one tab for specific members in UD5. I though the way to do this would be to use the literal parameter values in the Dashboard Properties. I have tried entering the following: param5=member1 and done this for 4 dashboards. The problem is, ALL the dashboards have the value of member4 since this was the last dashboard in the list to be rendered. If I swapped the order (1,2,4,3) then all dashboards have member3 as the filter. I have tried setting the parameter up as a literal and input parameter and it behaves the same way. Is there something wrong with the syntax? TIA, James1.8KViews0likes7Comments