ColumnMapping doesn't match source or destination
Getting this error while loading data from BI Blend table to the stage data in the workflow. We have five workflow and trying to union to load the data to the stage & eventually to the cube. However when we load from one table it fail & give column mapping error but clear data and reload next one then it goes through.6Views0likes0CommentsTransformation Event Handler reviewing pre-transformed (stage) and post-transformation data?
Hi, My colleagues and I are interested in reviewing pre-transformed data side-by-side with the records from post-transformation data, as we're looking to move our transformation process further upstream and we wanted to validate the accuracy of our new transformation process against OneStream's transformations. I've reviewed the examples in GolfStream in the transformation event handler and I understand how to review the stage data, but I'm unsure how to find the matching transactions after they get transformed. Has anyone done anything similar before and would be able to share insights into how I can review the data at the validate and match them to the records in stage? Thanks! Alex18Views0likes3CommentsData import from Stage to Cube
Hi, We successfully imported data from stage to cube. But while creating cube views, I am getting fewer records. Not all data is showing up in cube view. I checked the tables in the database; they have all the lines, but the cube view is importing only the first line. What can I do to get all the lines calculated in Cubeview? This account has 1343 records but cubeView fetches only 1st line.Function to return the period associated with a date, when the period is 4-4-5 or 5-4-4
Has anyone written a complex expression that takes a date as an input, and determines the period associated with the date, when periods are not based on calendar ends (for example, 4-4-5, or 5-4-4)? There doesn't appear to be a BRApi function for this, but perhaps I'm missing something. Absent a function, what techniques are recommended? Thanks!Derivative Rule
Hello, I'm trying a Derivative Rule where I've one source target account which needs to be mapped to an another account and combination of attributes, the idea is it should create new row for each account attribute, but as I'm using multiple attribute values at once it throwing me an error Please let me know what I'm missing out or what I'm doing wrong from the below expression. A#[56000]=[ABC]:A1#[ACC-*;FTM-*;BTSRR-*;BPR-*;BSC*;CON-*]74Views0likes3CommentsConsolidation- Calcstatus showing CN for all period.
Hi Everyone, We recently migrated from 7.1.3 to 8.4 . after migrations, we are facing issue in Calcstatus- Consolidation from Bottom to Top ( Parent). we tried to consolidated-calcstatus from beginning of the data to till now. But its not running properly or not showing value in parent level. after closing cubeview again its showing CN. is there anyone faced this issue and find the solutions?How to setup transformation rule to map if an item is a child member of a (another) dimension parent
I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension. ACCT600 DEPT101 --> ACT_EXP600_100 ACTT600 DEPT321 --> ACT_EXP600_100 Where departments 101 and 321 are descendants of Dept_TotRD2KViews0likes4Commentsomit a derivative rule, but only for a specific period
Hi, I’m currently working on a project where I need to omit a derivative rule, but only for a specific period. I'm looking for the most effective and clean way to achieve this without disrupting other rules or calculations that remain in effect. Does anyone have experience with this or suggestions on how best to approach it? I’d appreciate insights on both technical implementation and best practices to ensure future maintainability. Thank you,194Views0likes2CommentsNew connection requiring a date and scenario transformation rule
I cloned an existing connection that pulls the Scenario and Date from the workflow. The new connection is requiring me setup a New Scenario Transformation rule that is basically Budget --> Budget and time rule 2024M1 --> 2024M1. The connection I cloned doesn't require the additional rules and was pulling Actuals. All my Data Sources, Scenario, and Workflow settings seem the same. Any suggestions on what I am missing? I don't want to maintain the time rules, so that's why I'm trying to see what I'm doing wrong.Solved172Views0likes2Comments