Conditional Formatting in CubeView in the "annotation" or other "Text" cell
I would like to apply conditional formatting to a Cube View column that contains "Annotation", "Variance Explanation" or other textual data. I have tried IsNoData and "CellAmount" conditions, but with no success. I would appreciate any direction. Thank you! Yan SavinskySolved11KViews0likes20CommentsLoad 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.Solved9.8KViews1like15CommentsAccess to the registry key 'Global' is denied.
I may have found a bug in OneStream. I build a small CV - 10 by 3 columns with a row that has column override calling a small Dynamic Calc formula. I'm getting this error message, in System> Error log, when I run a cubeview. Has anyone seen this error message before. . If you can give me a clue to narrow down, that's fine as well. Unable to initialize XF App Server Metrics Thread on application server APP01. Access to the registry key 'Global' is denied. ---------------------------------------- Description: Unable to initialize XF App Server Metrics Thread on application server APP01. Error Time: 4/12/2022 4:57:02 PM Error Level: Error Tier: AppServer App Server: APP01 App Server XF Version: 6.1.1.11424 App Server OS Version: Microsoft Windows Server 2012 R2 Standard (6.3.9600.0) Session ID: 00000000-0000-0000-0000-000000000000 Error Log ID: 7053dc3d-9ea3-4da1-b144-d91a4bc70328 Total Memory: 34,359,201,792 (32.00 GB) Memory In Use: 2,713,128,960 (2.53 GB) Private Memory In Use: 3,351,609,344 (3.12 GB) Peak Memory In Use: 3,154,239,488 (2.94 GB) Maximum Data Records In RAM: 6,442,350 Number Of Threads: 68 ---------------------------------------- Exception Type: XFException Thread Id: 21 Message: Unable to initialize XF App Server Metrics Thread on application server APP01. Source code: XFServerMetricsThread.cs, line 138, method PerformInitialProcessingInThread Stack Trace: at OneStream.Shared.Engine.XFServerMetricsThread.PerformInitialProcessingInThread(SessionInfo si) in D:\Source\Shared\Engine\SharedEngine\BackgroundThreads\XFServerMetricsThread.cs:line 138 at OneStream.Shared.Engine.XFServerMetricsThread.WorkerThreadFunction() in D:\Source\Shared\Engine\SharedEngine\BackgroundThreads\XFServerMetricsThread.cs:line 63 ---------------------------------------- Exception Type: Unknown Message: Access to the registry key 'Global' is denied. Stack Trace: at Microsoft.Win32.RegistryKey.Win32Error(Int32 errorCode, String str) at Microsoft.Win32.RegistryKey.InternalGetValue(String name, Object defaultValue, Boolean doNotExpand, Boolean checkSecurity) at Microsoft.Win32.RegistryKey.GetValue(String name) at System.Diagnostics.PerformanceMonitor.GetData(String item) at System.Diagnostics.PerformanceCounterLib.GetPerformanceData(String item) at System.Diagnostics.PerformanceCounterLib.get_CategoryTable() at System.Diagnostics.PerformanceCounterLib.CounterExists(String category, String counter, Boolean& categoryExists) at System.Diagnostics.PerformanceCounterLib.CounterExists(String machine, String category, String counter) at System.Diagnostics.PerformanceCounter.InitializeImpl() at System.Diagnostics.PerformanceCounter..ctor(String categoryName, String counterName, String instanceName, Boolean readOnly) at System.Diagnostics.PerformanceCounter..ctor(String categoryName, String counterName, String instanceName) at OneStream.Shared.Engine.XFServerMetricsThread.PerformInitialProcessingInThread(SessionInfo si) in D:\Source\Shared\Engine\SharedEngine\BackgroundThreads\XFServerMetricsThread.cs:line 138Solved8.4KViews0likes1CommentCube 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).Solved7.3KViews0likes11CommentsHow 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, MustafaSolved6.6KViews0likes10CommentsPossible to set up a CV or QV showing stage data?
Hi all, We have data coming into Import/stage that subtotals to zero when it validates/maps into the cube. We need to review this data in import/stage before the validation and the easiest way would be a QV or CV instead of having the user manually go into the workflow and export the data. I thought accessing stage data in a QV/CV was possible but I can't find specifics. Any direction would be useful - thanks!Solved6.4KViews0likes9CommentsError: 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!Solved6KViews0likes4CommentsHow to pass standard formatting conditionals to an XFBR rule?
Hello: Looking for guidance on how to implement an enhanced conditional formatting check. It's quite simple, apply some formatting based on the account type. Consider the example of a single row CubeView with one account as the member filter: A#A87999. Formatting should be applied if the account is a Liability type. I have a mostly working XFBR helper that can correctly apply formatting but only if I hardcode in the account reference. Obviously that won't work for all but the simplest CV as reports are often dynamic with Member Expansions. The mainly working formatting syntax as currently written: If (XFBR(XFBR_FormattingHelper, AccountTypeIsLiability, Account=[A8799])=True) Then TextColor = Red End If How do I make the parameter dynamic? I've tried the following: ... Account=RowE1MemberName ... Account=|RowE1MemberName| ... Account=[RowE1MemberName] ... Account=[|RowE1MemberName|] None seem to work. Is there a different way to reference the standard available conditionals? Thanks, DaveSolved6KViews0likes6CommentsUnable 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!Solved5.9KViews1like8Comments