ContributionsMost RecentMost LikesSolutionsRe: Refresh XFGETCELL excel sheet I have not tried with XFGETCELL formulas. I know of users with Cube Views in extensible documents to achieve this. Some Report Books have a loop for e.g. [Member].ChildrenInclusive to have static ...Re: Question: Is it possible to run an automated consolidation task every hour using only the task Task Scheduler has been available since this post. e.g. Hourly consolidations during close days can be set by the system admin. Re: Pos / Neg check of total amount but keep all dimensions for future mapping Are you netting Intra-Profit/Cost Center within the Entity? Re: 24 Month PLP Dataset - Import to cube Hi Scott, An alternative that could be used would not preserve the "old" people plan in the same scenario if planned annually. If such a rolling/working scenario is used then the plan from WFYear...Re: Retrieve Parent property Hi Philip, For that List I just used the grid view on the dimension editor (similar to a cube view member filter) Generally I look top-down in the member list rules, as I only needed the p...Re: Retrieve Parent property Hi Philip, If you have the parent then it should be possible to retrieve a property. This is a Text1 property of a member in Golfstream: image.png1322×44 2.92 KB The Actual and 2019M1 c...Re: Spread sheets - Use of Table View Table Views Simplified Hello Darpan, please try the word search “Release Details”, can you see the section for the new release 6.4.0? Another place to check is page 19 of the “Table Views User G...Re: Spread sheets - Use of Table View As relates to formatting, OneStream XF version 6.4.0 now has two new table view possibilities: HeaderFormat ColumnFormat There are further details in the OneStream Academy video “Table Views Simpl...Re: Insert Rows using Spread sheet Hi, do you have the “Table Views User Guide” available? On page 14 there is an example helper similar to his code: Dim tableView As New TableView() tableView.CanModifyData = True tableView.Numb...