ContributionsMost RecentMost LikesSolutionsExcel Macro Enabled Workbooks (.xlsm) not working within OneStream Spreadsheet Hi all, Currently we are trying to automate some offline reporting processes via excel macro enabled workbook (.xlsm). Basically these files contain both XFGetCell and regular excel formulas and th...Extract Active Entity list from OneStream by using Data Management Job Hi all, Happy New Year! Is there a way of extracting an active entity list from OneStream including Entity Name, Description, and Currency fields by using a data management job?Any ideas will be app...SolvedAggregate UD1 by entity dynamically across two cubes Can we use an aggregated UD1 with a dynamic calc member in the Flow dimension across two cubes? We have dynamically calculated members called ‘AggDetail’ in Flow Dimension with a rule on member fo...Re: Aggregate UD1 by entity dynamically across two cubes Sorry for the confusion. Both cost centers and parents that we are testing are under the Financial Details. Setup looks fine for this ‘AggDetail’ dynamic calc member in Flow dimension. All cost ce...Re: Aggregate UD1 by entity dynamically across two cubes Thank you for your feedback. The flow member ‘AggDetail’ is already set to dynamic calc and working fine for all UD1 base members which are created under the 'Financial Detail' cube in dimension li...Re: Dashboard: Combo box with bound parameter Hi Lee, could you please send it to me atShetal.Patel@xylem.com. Thank you! Re: Extract Active Entity list from OneStream by using Data Management Job That trick worked. Thank you all for your help and guidance. Regards, Shetal Re: Extract Active Entity list from OneStream by using Data Management Job Sai, I was able to pull the entity metadata into a csv file by using the BR you attached earlier. Is there any way to exclude inactive entities in the rule? The current rule is pulling all entities (...Re: Extract Active Entity list from OneStream by using Data Management Job Thank you, Sai, for your guidance and attaching the sample BR here on the forums. I will try this and let you know if I have any questions . Re: Extract Active Entity list from OneStream by using Data Management Job Thanks for your feedback. Can you please throw some ideas here and see if that works with our requirements and current application setup?
