Troubleshooting FlipSign
Hi all, I'm trying to build a trial balance that shows line items in their natural debit/credit balances (e.g. - revenue, liabilities, and equity showing up as negative, and all else showing up as positive to arrive at a balanced ($0) report). However, we have some contra-accounts within our Accrued Expenses roll up that should show up as debits instead of credits. The accounts all begin with JDE_1 so I thought I could use the IF statement below to change the formatting for them, but the IF doesn't change anything (everything shows up as a negative, rather than accounts beginning JDE_1 being positive). Does anyone have any ideas as to what may be going awry? This IF statement has worked in other cube views that I've built, so I'm at my wit's end as to why it wouldn't be working here! If (RowE1MemberName StartsWith 'JDE_1') Then FlipSign = False Else FlipSign = True End If
Format Cube View based on third Header Override expansion
I am using header overrides on my columns to create three column expansion levels. I need to add conditional formatting based upon the header display text of "HPU" in this third expansion so that only sections with "HPU" in the header are set to three decimal places. I do not want to build every HPU column separate from the others, as this would require the build of 108 columns, instead of 12 columns. The system will not let me call that third expansion level in my conditional formula. Any help would be greatly appreciated!Dynamic Substitution Variable
Hello, I'm working on writing a budget report for my company and we have these summary accounts that all start with "S_" and the parent name (i.e. ExtSales would be S_ExtSales). Is there a way I can use substitution variable on my column override, where I wouldn't have to go in and change every line to update the override? Thanks, Will
Pov Error in calculated column while saving text comments in cube view
Dear colleagues, Could you please advise why error Pov occurred in cube view calculated columns (I use formula GetDataCell in member filter in these columns) when I click save button in order to save text comments in column VarianceExplanation (this column contains member V#VarianceExplanation). When I reload this cube view again this error removes, and I also see that text was saved. See below error:
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?
Hide zero data from a chart
We have a chart in which data will be at 0 for most of the year. Is there a way to tell the chart not to print the remainder of the line if it is 0? We tried to set up a member to return Nothing if the data = 0. It looks like the chart is interpreting Nothing as 0. Is there a way Ii can say if a cell is 0, set it to NoData. And would that make the chart stop showing the lines on 0? As we move through the year the actual number will get bigger and the drop to 0 for the remaining months will look even worse. Thank you, Scott
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.Cube View XFBR Formatting - How to get Entity on Cube View to use in BR
Hi, I have a use case to format V#Annotation text fields in a Cube View to Red when it's blank, with Entity in CV rows. I'm using a Literal parameter, and using the XFBR to return "Background=Red" for the purpose. The issue I have is that I cannot seem to get Entity from Cube View to use in XFBR. Since Scenario and Time are tied to Workflow, can get those with no issue. Below is my code section to get Scenario, Time and Entity, but Entity is null when I checked inside the XFBR rule. string wfSceanario = args.SubstVarSourceInfo.WFScenario.Name; //works string wfTime = args.SubstVarSourceInfo.WFTime.Name; //works string currEntity = args.SubstVarSourceInfo.PovMembers.Entity.Name; //doesn't work Anyone has advice on how to get the Entity name used in Cube View Rows, in my case? Since Entity is not passed, all my cell rows are Red now. My Row definition in the Cube View: Appreciate the help!
