Force Excel to store the source number (no scaling) when CV is exported
Hoping someone out there has some ideas on how to make this work... Let's say we have a cube view containing a parameter that allows the user to select a scaling option (millions, thousands or no scaling). The results of the parameter are stored in the CV's default CellFormat. Currently, when the CV is run and exported to Excel; regardless of the scaling selected by the user, the display in Excel is in thousands and Excel stores the entire number (unscaled). For example - if scaling selected is millions: If the number is 345,773,247.11; it displays in the CV as 346, it displays in Excel as 345,773 (but the stored number shown in the formula bar is the correct source value: 345,773,247.11). In other words, regardless of whether user selects thousands, millions or no scaling.... Excel displays as thousands and stores the correct number. If I try to change the Excel format to display in any other way (i.e. millions), it will store the scaled value based on the format and no longer stores the full number. This happens even if I force ExcelUseScale=False. The goal in this exercise is to figure out a way to "display" the exported CV in Excel exactly as it appears in the cube view but still retain the whole number. Using the above example, I would like to see this result: CV Displays 346 Excel Displays 346 Excel stores 345,773,247.11 Is this even possible? I have tried multiple ways to make this work including manual formatting, XFBR, parameters, etc., but I still can't determine the exact combination of formatting options that will result in what I want to see. Would love to hear if anyone has found a way to accomplish this. Thanks
Conditional Formatting in Cube view on Annotation members
HI, I am looking for an option to highlight text value in the cube view based on some condition. I have combo box which has parameter which pulling value from one of the DIM Member 1 = United States Member 2 = Canada Member 2 = Not filled If its not filled then I want to highlight red. Is there any option. I tried using XFBR but seems like it run on specific data unit onlyUnable 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!
Narrative Reporting Parameters
I'm currently using the Narrative Reporting MarketPlace Solution on OS version 8.4 and have successfully integrated Cube Views, Content, and other artifacts using QuickParts. However, I'm facing several challenges: Member Prompts on Report Checkout/Edits: Despite configuring parameters at both the report and report group levels, I continue to receive member prompts from the cube view every time I check out or modify a report. This differs from the expected behavior in guided reporting and dashboards, where parameters are supplied automatically. Is this expected, or is there a workaround to prevent these prompts?
Dashboard: Combo box with bound parameter
Hi, I have set up a combo box that uses Bound List parameter "WfProfile_AssignedEntities" with defaul value WFProfile_AssignedEntities. Even though the default value is set, when I use it in the dashboard, it default to empty space and a drop-down where I need to pick up my workflow profile assigned entity. How can I make to show a workflow entity without needing to go in drop-down and pick up it from there?
How do I return description to XFBR from a multiselect prompt?
We are using the multiselect tool to gather certain entities for reporting, which will show up in rows in a cube view. We're returning to the cube view the values from the multiselect via an XFBR. When the user chooses the entities, we can't get the resulting members in rows to show as description, only as member name. Anyone know how to return the description in a cube view/report?
Can a button control two parameters simultaneously?
I have a button on a dashboard that needs to change the values of two parameters with one click of the button. Is this possible without building an XFBR? The "Bound Parameter" property implies it can only control one. Placing a comma between two parameters in this property does not acknowledge the second parameter.
Error saving attachment in Cube View
I want to give users the ability to add attachment in the cell with a dynamically calculated UD8 member. Dynamic calculation places the value of 1 into that intersection if the file attachment is present and the value of 0 if there is no attachment. I use these values to change the formatting of the cell if there is an attachment. I am an Admin and I have no problem attaching the file. However, other users are getting the "Error saving data attachment" message. I wonder what governs this and if I can give my users the ability to add attachments to that cell? Any suggestions are appreciated.
Dashboard - Time Parameter for Specific Cube Views
Hello - I have a dashboard with 6 buttons across the top - each one is set to display a different cube view. The time dimension for 4 of the CVs are set to workflow time, where the other 2 I want the users to be able to select a period from a list, because these 2 are designed to show historical variance commentary. I set up a member list parameter with the time periods and added it to the two cube views. Now when I open the dashboard, the prompt automatically appears for every CV. I checked and couldn't find a way to only have this prompt appear for the two cube views. What settings do I need to enable or disable for my dashboard so 4 out of the 6 run off workflow time, but when a user clicks a button for one of the 2 others, the time period prompt appears?Double Line Formatting
Hello, We currently print out a book to our general managers every quarter and our reports formatting seemingly changed without us changing. We use double underlines as our totals and previously it worked fine, but this quarter it looks like a solid line, but when you zoom in, you can see it's a double line. Is there any way I can fix this? I've tried changing the ReportBottomLine1Thickness and ReportBottomLine2Thickness size, but with no luck. Any suggestions? Thanks, Will
