Answer If not using a custom time dimension with weeks in place, the input frequency will not give you the option of weekly input. In this case, one could create weeks 1 – 5 within a UD for loading data. Using this approach would mean data is loaded ...
Question (cont) We see the attributes are held in a separate table and are curious how we could see them in the LDPG? Answer Yes, the view in the database vStageSourceAndTargetDataWithAttributes contains all Stage data with Attributes and can be quer...
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 unable to resolve the error (unknown) you’re receiving, please open...
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
Answer There are 2 options that can be used to accomplish this: If the data doesn’t need to be preserved in the ‘working’ scenario, a reset scenario data management job would work. If data needs to be preserved in the ‘working’ scenario, an Extensibi...
Question (cont) We’ve tried using grid view and the metadata builder but haven’t been successful. Answer Consultants have developed their own tools which will have their own limitations (e.g., we’ve seen one which doesn’t cater for varying properties...
Answer Yes, this is possible. The following syntax will work: Remember that OneStream will look to the workflow that you have selected at run time, so you will need to ensure that you set up the relevant text property on the individual workflow step ...
Answer Each row in the Cube View becomes an item to forecast in predictive analytics. Be cautious with the number of rows in the Cube View It is possible to nest dimensions in the Cube View, but predictive analytics is not intended to be run across t...
Question (cont) A client requires a balance sheet that displays assets on the left and liabilities on the right. This can be achieved in Excel but we would like to use a Cube View/Books. Have you seen a Cube View report formatted this way? Do you hav...
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
Question (cont) Is it possible to load multiple S schedules? For I items, is it possible to pull the I-docs in any way? Documentation notes that pulling items does not pull the documentation. Is there a way to pull the documents attached? Answer Curr...
Answer There is not a built-in setting to allow variation of mappings by time. However, this could be achieved using conditional logic on a mapping rule (not available on One-to-One mappings). Depending on the requirements, it may also be possible us...
Answer You will lose the origin detail when you export data using a DM job and then try to reload that data through stage. Everything in the file will be loaded into the import member. Even if you could extract everything by origin and then load via ...
Question (cont) I have entities consolidated into EUR parents for local GAAP reporting (including journals in C#OwnerPostAdj). The data (C#Local and C#OwnerPostAdj) is copied into a separate scenario for US GAAP reporting. However, I need to consolid...
Answer Yes, this is possible. In the Extensibility rule properties, you need to declare the dashboard extender rule properties Then call the appropriate function from the dashboard extender rule. Source: Office Hours 2021-MM-DD - Partner Enablement
Answer Generally, the recommendation would be to use business rules rather than Data Management copy sequences. Business rules: Give you more flexibility/choice in terms of what type of data is copied (e.g., you may need to be selective regarding sto...
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 with the process using an event handler business rule. However, you a...
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-04-29 - Partner Enablement
Answer One approach would be to use a bound list parameter together with a dashboard dataset business rule. Source: Office Hours 2021-04-29 - Partner Enablement
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 documentation regarding the various si (session info) calls. The session inf...
akloepfer
