Recent Discussions
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?LarysaZ3 years agoNew Contributor II22KViews0likes47CommentsHow to install Excel addin?
Hi, I need the excel add-in. Can you please help me with the same. Thanksishaanand2 years agoNew Contributor II12KViews0likes1CommentCombobox Multiple select option.
Is it possible to have multi select option in Combo box ( Dashboard component)? Thanks & Regards, Madesh KSolvedMadesh3 years agoNew Contributor III11KViews0likes20CommentsConditional 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 SavinskySolvedYanSavinsky3 years agoNew Contributor III10KViews0likes20CommentsGroup Columns/Excel Outline in Columns on Cube Views
Hello: Has anyone had any success with grouping columns in a cube view in a report linked to excel, or grouping them as they export? Of course in the data explorer version you can use the tree function and toggle the row expansion mode to get the intended effect, and in rows you have the excel outline settings you can play with. However, there doesn't seem to be a way to manage this using settings. And obviously if you format the cube view when linked them refreshed the column grouping goes away. Interested to hear and thanks!SolvedJamesKirkby4 years agoNew Contributor III9.8KViews0likes16CommentsLoad 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.SolvedSKVK3 years agoNew Contributor III9.7KViews1like15CommentsReporting - Books - File (xfDoc)
Hello, I would like to create a report book that includes several cube views and an xfdoc (ppt cover page). I added the xfdoc as an application database file and pointed it to the working URL. However, when I run the report book I get a blank page. I can't figure out how to get it to render the File (xfDoc). It does render all the cube views as expected. And I confirmed that my standalone xfdoc is working as well. Thanks, SeanSolvedCAIGuySeanF3 years agoContributor8.8KViews0likes12CommentsRetrieve Parent property
SOURCE: ONESTREAM CHAMPIONS Hi All, I am trying to find a way to create a report that shows the Entity and the Parent in a column next to it. I tried to do this by using the functions =XFGetMemberProperty() and =XFGetRelationshipProperty(), both returns an error when I try. =XFGetRelationshipProperty(“Entity”,"",B15,“Parent”,"","") returns “#ERROR:Parent” =XFGetRelationshipProperty(“Entity”,B16,"",“Parent”,"","") returns “#ERROR:Member Name” =XFGetRelationshipProperty(“Entity”,B17,"",“Parent”,“ACTUAL”,“2021M1”) returns “#ERROR:Member Name” =XFGetRelationshipProperty(“Entity”,B4,B5,“Parent”,"","") returns “#ERROR:Parent” =XFGetMemberProperty(“Entity”,B13,“Parent”,“Finance”,“Actual”,“2021M1”) returns “#ERROR:Finance” =XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR:Parent” =XFGetMemberProperty(“Entity”,B14,“Parent”,"",“Actual”,“2021M1”) returns “#ERROR:Parent” =XFGetMemberProperty(“Entity”,B11,“Parent”,"","",“2021M1”) returns “#ERROR:Parent” =XFGetMemberProperty(“Entity”,B12,“Parent”,"","","") returns “#ERROR:Parent” as a reference, I tried the same function on “currency” and that works. =XFGetMemberProperty(“Entity”,B21,“Currency”,"","","") returns “EUR” I am assuming that the complexity lies in the fact that the parent could vary in time (?) . I hope some body can help on this thanks. Philpling3 years agoNew Contributor II8.7KViews0likes6CommentsAccess 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 138SolvedDavy3 years agoContributor8.2KViews0likes1Comment