Announcement
ABCRecent Activity
Cube View - Conditional Formatting
Hi everyone, I'm currently working on a Cube View and would love some help with setting up conditional formatting based on a comparison between two columns. Specifically, I’m trying to highlight in red any cell in the “Actuals” column (Actual CPK @ ACT 2024 rate, Jan 2024) where the value is greater than the corresponding value in the “Cost per kg” column. To give you a clearer picture, I’ve attached a screenshot showing the layout I’m working with. The "Cost per kg" values are budgeted figures, and I'm comparing them to actuals from 2024 to identify any overages. I’d like the Cube View to visually flag these instances, so they stand out during reviews. Of course, the numbers in both columns are exemplary. In the rows I have different Entities. Has anyone done something similar or can guide me on the best way to achieve this? Thanks so much in advance for your support!8Views0likes0CommentsDynamic Dashboard & Cubeview parameters
Hi, I have a classique cubeview that uses !prm_entity! as Entity POV. When using classic Dashboards, everything works as expected. When converting the dashboard from "Embedded" to "Embedded Dynamic" and using a simple Factory service to add the template cubeview stored component, nothing more: then the !prm_entity! POV of the cubeviews seems not interpreted at run time, no prompt showup and this cubeview displays a blank page. When checking cube POV we can see parameter is handled like a string in the POV. Any idea what basic setting i am missing to do in the Dynamic Dashboard way to let OS prompt for the prm_entity parameter value? Thanks in advance,sylvainremy20 hours agoNew Contributor38Views0likes2CommentsImport parser on a Batch File
Hello, I've successfully set up an automatic upload using the Harvest Folder. However, I want to use the Skipline functionality within the file to reduce the import size. This works perfectly when I manually import the file into the specific Import Step. But when using the automatic upload via the Harvest Folder, the Skipline functionality doesn't seem to be applied. Does anyone have an idea for a possible workaround?JoBo20 hours agoNew Contributor7Views0likes0CommentsHow can I remove empty values from GetDataBuffer and obtain the entity with Text1, Text2, Text3?
Hi Everyone. I would like to know how I can remove zero values in my GetDataBufferUsingFormula. Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPARTMENTS:U2#ALL_PRODUCTS:U3#CORP_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None,A#411000)") And from the result, I would like to obtain the entity, and from that entity, know its Text1, Text2, and Text3. However, for now, I see that I can only obtain the account and the rest of the properties such as the UD Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPARTMENTS:U2#ALL_PRODUCTS:U3#CORP_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None,A#411000)") api.Data.FormulaVariables.SetDataBufferVariable("DatabufferCalc", DatabufferCalc, True) For Each sourceCell As DataBufferCell In DatabufferCalc.DataBufferCells.Values 'I would like to obtain the entity and Texts Dim account As String = sourceCell.DataBufferCellPk.GetAccountName() BRApi.ErrorLog.LogMessage(si) NextMarco2 days agoContributor II20Views0likes3CommentsAccount is invalid due to Aggregation property
I have informational account created to store some Include/Exclude value by Entity. Now, I dont want this account to be translated and consolidated so, I have tagged AccountType to "Non Financial" while Aggregation to False. However when I turn on false its become invalid while True makes it Valid for input. Any idea what causing the issue? Based on the OS doc any informational account can be set to False.pranav462 days agoContributor II5Views0likes1CommentConsolitation Relationship Properties
Hi, I want the hierarchy illustrated below. Entity B owns 90% of entity C, and in the consolidation of entity B we calculate minority interests of 10%. At this step, I have no doubts. However, entity A owns entity B 100% and also owns entity C 100% (90% indirect + 10% direct). So, in the consolidation of entity A, we need to eliminate the calculation of minority interests done previously in the consolidation of entity B. I don't know how to set the properties to do this. Can someone help me?tsequeira2 days agoNew Contributor II6Views0likes0CommentsHELP! Microsoft excel is waiting for another application to complete an OLE action after 8.5 Upgrade
Hello Experts, We have a few users that are getting below error while trying to close Excel windows after OneStream upgrade. Error text "Microsoft excel is waiting for another application to complete an OLE action" Can someone share any insights or guidance on resolution here? Regards, NDNirmal_Daswani2 days agoNew Contributor II11Views0likes1Comment
Getting Started
Learn more about the OneStream Community with the links below.
Featured Content
A focus on Developer Education is coming to OneStream, and your feedback is needed!
OneStream is creating a Developer Education (DevEd) program tailored specifically at creating a dynamic learning experience for you, our amazing developer community. We know that building applic...109Views4likes4Comments