Turn off suppression of repeated member names in a Cube View
I am well aware of the "Suppress Repeating Member Names" True/False box on a Quick View. I am looking for the exact same toggle on a Cube View. I could have sworn this was a very easy thing but I don't see it. In the below Cube View example below, the first row member expansion is the Actual scenario and the second is a TreeDescendants on the Account dimension. I want the "Actual" scenario to repeat all the way down on each row. Am I missing something easy here?
How can I retrieve in a cube view the assigned workflow for every entity ?
Hi, A question that come back rather often is how to retrieve in a "user friendly" format the workflow an entity is assigned to. You can find hereunder a dynamiccalc you can assign to an UD8 in order to retrieve that information. Hope this helps. Kind regards, Aymar 'This dynamiccalc member will show the workflow profile of the Entity as an Annotation 'User need to have access to the CubeRoot workflow profile Info If api.View.IsAnnotationType() Then Dim sourceSQL As New Text.StringBuilder Dim returnedText As New Text.StringBuilder Dim wfCubeRootInfo As WorkflowCubeRootInfo = TryCast(BRApi.Workflow.Metadata.GetCubeRootInfo(si, BRApi.Workflow.General.GetWorkflowUnitPk(si).ProfileKey, False),WorkflowCubeRootInfo) If Not wfCubeRootInfo Is Nothing Then sourceSQL.Append("SELECT [EntityMemberID]") sourceSQL.AppendLine(",[ProfileName]") sourceSQL.AppendLine("FROM [WorkflowProfileEntities]") sourceSQL.AppendLine("INNER Join [WorkflowProfileHierarchy] On [WorkflowProfileKey] = [ProfileKey]") sourceSQL.AppendLine("WHERE CubeRootProfileKey = '" & wfCubeRootInfo.CubeRootProfile.UniqueID.ToString & "'") Dim dt As DataTable = api.Functions.GetCustomBlendDataTable(BlendCacheLevelTypes.Custom, "entity_WFPAssignment", "Application", sourceSQL.ToString) If dt.Select("EntityMemberID = " & api.Pov.Entity.MemberId).Count() > 0 Then For Each dtRow In dt.Select("EntityMemberID = " & api.Pov.Entity.MemberId) returnedText.Append(dtRow(1).ToString).AppendLine Next Return returnedText.ToString Else Return "Not Assigned" End If End If Else 'Return a NoData Datacell Return api.Data.CreateDataCellObject(0.0,True, False) End IfEnhance your OneStream experience with Emojis!
Integrating emojis into OneStream workflows, like :memo: for forms and :crystal_ball: for forecasts, enhances clarity and user engagement. Simple to set up, just copy and paste your chosen emoji into workflow titles for an instant visual upgrade. Interested in setting this up in OneStream? Dive into the world of emojis and elevate your interface today! :rocket:
Optimize CubeView performance in Excel
I have Cubeview which takes ~50 secs to refresh in OS. When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins. It is simple insert and refresh i.e. I do not have anything additional like VBA code etc in Excel. Is it normal for CV to take to take longer to refresh in excel? Any suggestion to optimize the Cube view refresh in Excel? Many Thanks.
CV format total line different from row expansion details
Hi all, Is it possible to format the top row of an expansion different from the expansion details in a cube view if they are the same line on the CV set up? For example, I would like the formatting to have the Total Product line bold with the details under it not bold and with only one expansion at Total Product. It seems the only way I can do that is to have one row in the CV set up for Total Product formatted one way and a separate line below for the details formatted another way (result in screenshot above). The problem is then my expansion isn't really where it should be and the first detail line (Branded Pharm) will always show. I can't figure out a way to do this but if it's possible, please let me know!
Cube View - Excel Column Headings
Is there a way to have nested column headings centered and merged when exporting a cube view to excel? I have nested columns and want the top column header to be centered and merged over the bottom columns. It does this automatically for a pdf export but the excel export repeats the top header for each column. Excel vs. pdfMerge and center on headers for cube views
Hi, Are there any updates on merge and center on headers for cube views? It was informed that the enhancement is expected in one of the quarter releases in 2020. Do we have it available? https://community.onestreamsoftware.com/t5/Office-Hours/Question-Are-there-any-updates-on-merge-and-center-on-headers/ta-p/1503 Thanks
