Skip to main content
V
vijay
August 29, 2023

Load data from custom table into Import step of workflow

  • August 29, 2023
  • 2 replies
  • 0 views

hi,

I have created the custom table and loaded the records into it using the Finance BR. Finance BR is called by the DM step and now i have to read the custom table records and render  into the import step of the workflow on clicking the load and transform button . Any steps on this is appreciated.

 

Thanks

 

 

2 replies

M
MarcusH
August 29, 2023

Create a Connector Data Source which you add to your WF. That specifies a Connector Business Rule to execute which returns the data table containing your data.

The BR has 2 sections you need to fill in: GetFieldList and GetData. And then you need to specify the ProcessData command - you might build the return data table using SQL or through script. This post has a bit more info:

https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/Connector-Rule-Object-reference-not-set-to-an-instance-of-an/m-p/22203

 

V
vijayAuthor
August 31, 2023

I tried the above , data is returned from the custom table ,But am getting the below error in the transformation rule even though i have the year 2024 and Forecast_Working in the TR.

Summary: No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source.

 

vijay_0-1693504008284.png

 

M
MarcusH
September 1, 2023

That error means that the import process cannot identify what scenario and/or time period the data should be imported to. You have either not included the Scenario and/or Period in the source template or you have not added the Transformation Rules for the Source Scenario and/or Period.

V
vijayAuthor
September 1, 2023

Yes am about to share it. After makign some changes to TR , the log has the rows loaded . But am not seeing the rows in the import section.  Not sure whether the custom table data can be loaded into the staging table of import. 

vijay_0-1693579464110.png

 

C
ckattookaran
September 1, 2023

Do you see data in the validate tab? maybe your file is having a different time and scenario and it is loading to that workflow?

Terms & ConditionsAccessibility statement