Load comments to the cells through Data input or Forms
Team Is there a way we can add long text like comments to the cells through Forms? Am trying to build a cube view with data and comments to it which is visible on view rather than adding it as "note" or "attachments". Please see the sample image below on the requirement.
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).
How to grab Prior 6 months in CV
Hi All, I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on. I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated. Thank you, Mustafa
Error: Value is either too Large or too Small for a decimal
Hello, I am receiving an error "Value is either too large or too small for a decimal" in a Cube View when I try to divide values in two rows using the cube view math. When exported into Excel the math for the same division yields 8.2, which does not seem like it would be too large or too small for a decimal. Example: GetDataCell(A#NetInc / A#Diluted_Shares_Outstanding_AsAdjusted_DC) I am trying to divide the two rows shown above. Using the Excel divide function produces a clean 8.26, which I would not expect to be "too large or too small for a decimal" The second member is a Dynamic Calc member that dynamically changes the view to either YTD or QTD depending on user's POV, but is not doing any math on the account value itself. Any help or insight into this issue would be appreciated. Thank you!
How to add two dimension (UD2s) hierarchy in same row/column in cube view?
Hi All, I am trying to add two UD2 dimension members in the Cube view member filter and obviously , its not allowing me to enter them. I went through the approach of creating a dimension in UD8 and then copying all the data from the UD2 dimension to UD8 dimension in order to show the two columns. However, it is not working for me. I used the following code in dynamic calc formula for UD8: B2C_PGC_Provider so that I can reference it to UD2 ( all member dimensions and included data): Dim U2Filter As List(Of Member)=api.Members.GetBaseMembers(api.Pov.UD2Dim.DimPk, api.Members.GetMemberId(dimtype.UD2.Id, "Programs_Provider")) For Each memberObj In U2Filter BRApi.ErrorLog.LogMessage(si, memberObj.Name) Next. Please let me know what is wrong and how this can be resolved.
