OneStream Community

OS_Pizza

What alterantive solution you have build for Workforce Planning. I don't want to use People Planning Market place solution.1) Run calculations inside the cube by storing all employee information.2) Relational Table + Cube.Can you give me a top level ...

OS_Pizza

I am trying to use LockWorkflowUnitDescendants with a non standard channel. The logic seems to allow express use of 'NoDataLock', 'AllChannelInput' and 'Standard', but for custom WF Channels, can't seem to identify how to get the GUID.'Dim wfChannelI...

OS_Pizza

I have Import/validate/Load workflow.After the validation step , I want to run a business rule that can do the following -1. Sum up the amount for all records with the same Product code in the transformed table.2. Check if SUM = 0 for individual prod...

OS_Pizza · 02-17-2023

Can you please guide me the definition for the below points - 1) What is number of NODATA,Zero,Real,Derived cells ? And why are they all under NODATA Status ?

OS_Pizza · 02-15-2023

1. Why is the "Total number of stored records" same across all months for one year ?

OS_Pizza

You can enable detailed logging in the WFP and then run it . Check for more details in the child step in Task Activity.

OS_Pizza

To exportdata w/o using DM -1. Use fdx query.2. Use Cubeview export to excel query.3. use streamer to write data from the table to csv. To import data using csv file 'File To Import Dim fileName As String = "BaseTrialBalanceDataWithComment.csv" '<- D...

OS_Pizza

May be you can customized and use the below solution.https://medium.com/me/stats/post/5d53adf4fc81 Please give kudos and mark answer as accepted solution if it helps resolve your query.

OS_Pizza

There are different tables in the backend which connects Dimensions and members together.1. Dim Table - This gives you dimension Name and Dim type id. 2. Member Table -3. Relationship Table - You can write a sql query using the data adapter to output...

OS_Pizza

@MauroGallo @JackLacava FOUND THE SOLUTION If you check WorkFlow Channel table. It shows the uniuqe id corresponding to the custommadechannel.Use that unique id to convert into GUID and then use it in the same function directly. Dim stringToConvert ...

OneStream Community

User Statistics

User Activity

Workforce Planning

Locking an import profile using custom created workflow channnel.

Looking for a validation rule to validate data after transformation and before loading to the cube.

Dataunit statistics

Fields inside Data unit statistics?

Re: Workflow error on load step - Value cannot be null. Parameter name: type

Re: Can we Load data without using the workflow/DM

Re: Parcel Service email different dimension versions of the report based on different dimensions

Re: Table Name where Dimension are stored

Re: Locking an import profile using custom created workflow channnel.