Cube View Parametric driven column
I have a cube view that I need to modify so that in the second column we are getting data that is driven by the selection that the user makes for the first column. For example if the user selects a forecast for February to be in the first column, then the second column of the cube view would have to be the previous month’s forecast. Do you have any suggestions on how to achieve this view? Thank you in advance for any help and suggestions! I am going to attach some views of what I have in here so far (The second column reads OP plan as I have copied this view from another similar Cube View).
Unable to open shared Cube View
Hello, We are trying to use row and column templates in a Cube View but are using parameters to populate the names of those row and column template cube views. We get the below error and are curious what else could be issue as we have checked values of parameters and they are pulling in values expected (names of templates). Thanks!
Create a dependent dropdown list in SQL Table Editor
Hi, Is it possible to create a dependent dropdown list using a SQL Table Editor? Example below: If I select Entity A in the Entity column, I would like PC1, PC2 to be options within the Profit Centre column. If I select Entity B in the Entity column, I would like PC3, PC4 to be options within the Profit Centre column. I have tried using 'Selection Changed Server Task' to update a Literal Parameter that I can use as a basis for a Bound List parameter that I am attaching to the Profit Centre column , however this only appears to work after the row has been saved: I think it may be possible if the user was to save the row after choosing the Entity and then selecting a Profit Centre, but this wouldn't be an ideal user journey. Thanks, Mark
Default Value of a Delimited List Parameter Not Working
Hello Everyone, I am using a Delimited List Parameter which results a list of comma separated values from SQL through XFBR. When i use this parameter in Dashboard, it always shows as blank when it starts up, even though i have set the default value property. Looks like its a limition at this point of time. Are the any alternate ways we can use the default value for Delimited List Parameter in Dashboards ?How can we make header as bold and increase the header size in both report & excel?
Dear Community, We have a requirement to make all the headers in report as well as in excel to make it bold and to increase the size. Here, I wrote a Business Rule function in Cube View Extender to make the change. But, I see it's getting reflected for only one of the headers in the report. Here, I'm attaching the images for the reference. Any solutions to this are really appreciated. Thanks. -- This is what I have given in the report header. -- And this is the output when generating the report. This bold needs to be applied to all the headers given here. -- This is the output when I'm viewing it in the excel format. No changes are seen here. -- Cube View Extender Business Rule which I used.Member Dialog Parameter Type in a Dashboard
Hi everyone, Quick question re Dashboards. When you use a parameter in a Cube View there is an option to display the Member Filter using a "Member Dialog" Parameter Type. This shows you the results in a hierarchy that can be expanded or collapsed. When building an interactive dashboard I need to present the user with a large number of members to select from. The Combo Box option isn't particularly easy to browse through as it simply lists the members (albeit this can be indented with a BR to imply the hierarchichal relationships). Is there a way of replicating the Member Dialog Parameter Type in a Dashboard component? Regards, Lee
How to Achieve dynamic data retrieval: Current month + 12 months prior using SQL in Dashboards
Hi All, I am currently facing a challenge with my SQL code in dashboards and would greatly appreciate your help in finding a solution. The issue at hand is that I have hardcoded the code to pull data from tables, but now I need to modify it so that when a user selects a specific month (e.g., 2023M1), the dashboard displays data for the selected month as well as the 12 months prior to it. To provide more context, here is the query I am currently using: SELECT ISNULL(Name, 'Total |!SelectAcc!|') AS Name, SUM(CASE WHEN Period = '2022M12' THEN |!SelectAcc!| END) AS '2022M12', SUM(CASE WHEN Period = '2022M11' THEN |!SelectAcc!| END) AS '2022M11', SUM(CASE WHEN Period = '2022M10' THEN |!SelectAcc!| END) AS '2022M10', SUM(CASE WHEN Period = '2022M9' THEN |!SelectAcc!| END) AS '2022M9', SUM(CASE WHEN Period = '2022M8' THEN |!SelectAcc!| END) AS '2022M8', SUM(CASE WHEN Period = '2022M7' THEN |!SelectAcc!| END) AS '2022M7', SUM(CASE WHEN Period = '2022M6' THEN |!SelectAcc!| END) AS '2022M6', SUM(CASE WHEN Period = '2022M5' THEN |!SelectAcc!| END) AS '2022M5', SUM(CASE WHEN Period = '2022M4' THEN |!SelectAcc!| END) AS '2022M4', SUM(CASE WHEN Period = '2022M3' THEN |!SelectAcc!| END) AS '2022M3', SUM(CASE WHEN Period = '2022M2' THEN |!SelectAcc!| END) AS '2022M2', SUM(CASE WHEN Period = '2022M1' THEN |!SelectAcc!| END) AS '2022M1', SUM(|!SelectAcc!|) As 'TOTAL' FROM ( SELECT Name, |!SelectAcc!|, Period FROM Account_TABLE WHERE Period IN ('2022M12', '2022M11','2022M10', '2022M9','2022M8','2022M7', '2022M6','2022M5', '2022M4','2022M3', '2022M2','2022M1') UNION SELECT Name, |!SelectAcc!|, Period FROM Second_TABLE WHERE Period IN ('2022M12', '2022M11','2022M10', '2022M9','2022M8','2022M7', '2022M6','2022M5', '2022M4','2022M3', '2022M2','2022M1') ) AS a GROUP BY Rollup (Name) ORDER BY CASE WHEN ISNULL(Name, 'Total |!SelectAcc!|') = 'Total |!SelectAcc!|' THEN 1 Else 0 END, ISNULL(Name, 'Total |!SelectAcc!|') As you can see, the query currently involves hardcoding all the 12 months prior to the selected month, which is not an efficient and scalable approach. I am looking for a solution that allows for dynamic retrieval of data, enabling the display of the current month and the 12 months preceding it. For example, if a user enters "2023M1," the dashboard should show data for 2023M1 as well as all the 12 months prior to it. If anyone could provide guidance, suggestions, or insights on how to modify this query to achieve the desired dynamic retrieval of data, I would be immensely grateful. Thank You, RithikPassing a value in a book for a delimited list parameter doesnt seem to work.
I have a parameter called IntigrityScaling with parameter type "Delimited List" as below My cube view uses this delimited list twice. 1. As USD in |!!IntigrityScaling!!| -> it is used to display the description of the value 2. Under formatting -> I am using Scale = |!IntigrityScaling!| Cube view runs fine and prompt me to enter value for Scaling and and display both 1 and 2. The issue is when i pass this parameter in a book , it doesnt take the value and prompts me to enter the delimited list parameter. How do i pass a value to the delimited parameter without prompting me to enter ? I dont want this prompt to pop up after i run the book. NOTE= Liter paramter works fine when passing from books
