Data entity for the Financial dimension not working

(0) Share

Report

Posted on by rohit1900

439

Hi All,

I have created a custom entity for updating the financial dimension

I have a custom table and added a field default dimension and created a relation with DimensionAttributeValueSet

mytable.Defaultdimension == DimensionAttributeValueSet.RecId

Then I have created a entity to import and update the default dimension in the current Table like this

Under the entity -> Table datasource I have added a new datasource with TableName = DimensionSetEntity

Read only - yes, outer join,

and given the relation as below MyTable.DefaultDimension == DimensionSetEntity.RecId

When ever I tried to import the data or update I have getting below error

Results. Cannot select a record in Mytable (MytableStaging).
The SQL database has issued an error.
Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Error converting data type nvarchar to bigint.
SELECT

I have checked one standard entity Sales order lines V2 entity and it is working fine there not sure what i need to do more.

I have the same question (0)

All responses (4)

Answers (0)

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi rohit,

After adding new custom data source to your entity, have you done "Update staging table" by right clicking the entity?

After that do a synchronization and check.

Thanks,

Girish S.

Was this reply helpful? Yes No
rohit1900 439 on at

Like (0)

Report
Copy link

Link copied!

Hi that issue is resolved but now when ever I am tying to update/ insert the record it is not happening update the dimensions are not getting updated.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

DimensionSetEntity has "Is Read Only" property set to Yes. So, I guess you cannot use that entity for CRUD operations.

You need to think in alternate way to meet your scenario like trying different entities.

Thanks,

Girish S.

Was this reply helpful? Yes No
rohit1900 439 on at

Like (1)

Report
Copy link

Link copied!

I have used a unmapped field and it is working wrote some logic to populate the financial dimension fine but not sure why it is not working found same thing in Sales order line V2 entity it is working , nevertheless Thank you for the help.

Was this reply helpful? Yes No