ContributionsMost RecentMost LikesSolutionsQuestion: I am trying to clear out aggregated zero value rows after the transformation rules have been run but prior to the intersection validation. Can this be done without directly impacting/deleting rows in the stage tables? Question (cont) The client is loading rows with net zero values from the source system and currently these are being loaded to a suspense account. Answer It is possible to interact...Question: Do you have an example of a Table View Business Rule which allows a user to edit the table and save the changes back to the database? Answer The example in the Table Views documentation does work. However, any references to tables and columns will need to be updated to suit your own needs. Source: Office Hours 2021-...Question: Are there any special setup considerations when setting up a Large Data Pivot Grid against a SQL View or Snowflake? Question (cont) We have reviewed the reference guide and are still receiving an error we don’t fully understand. Answer No, there are no special / different considerations. If you’re una...Question: Is it possible to be able to reference rows that are not visible in Cube View calculations? Answer There is an enhancement pending for this functionality. Contact Support to be added to this request. From 6.0.0, Complex Cube View Column Math calculations can now be derived using...Question: Is it possible to launch the Load and Extract page from a dashboard button? Answer There is a Knowledge Base article (KB0010045 How to Open Another Onestream Page From a Dashboard) which explains how to use the XFPages options. This KnowledgeBase article details ...Question: Can I create a dashboard dropdown or list box which contains a representation of a hierarchy with indentation? Answer It is possible to represent a hierarchy using spacing. This would be achieved in a dashboard data set rule. Source: Office Hours 2021-03-04 - Partner Enablement Question: Looking at the time dimension, it seems only one time dimension can be created per application. If you add time profiles, it still uses the same time dimension of the application. Question (cont) Is this expected and what should clients do when they want to do some processes weekly and other processes monthly? Answer It is correct that each application has ...Question: Is it possible to display Task Manager tasks in a hierarchical view? Answer It is possible to display in the Gantt View, but not in a hierarchical view. Source: Office Hours 2021-05-13 - Partner Enablement Question: Is there any documentation to explain the difference between various si calls and the use of each? Question (cont) For example, in a single snippet, I can see references to si, api.si and api.DBConnApp.si but it is not clear why each is needed. Answer There is no specific documen...Question: With People Planning, is it possible to easily disable the ability the load / delete registers for certain users? Answer We would need more info on the design and set up, but Central Register loading is available. Source: Office Hours 2021-04-15 - Partner Enablement