How to apply MDS Business Rule Validations from SQL backend

Question

How to apply MDS Business Rule Validations from SQL backend

Prateek Gupta 5

Hello,
As I have been following Upload by Script method to load data into SQL Server MDS but unable to achieve the last and the foremost step that is how to apply MDS Business Rule Validations step from SQL backend after data load in SQL Server MDS.

I've followed multiple blogs to implement but I'm unable to find any proper solution for the above scenario.

Does anyone have any thoughts of what could be the correct approach to apply Business Rule Validations from SQL that could directly reflect to MDS frontend UI ?

Seeya Xi-MSFT 16,571 Reputation points

2023-02-23T08:14:58.57+00:00

Hi @Prateek Gupta,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya
Seeya Xi-MSFT 16,571 Reputation points

2023-02-24T05:49:28.7033333+00:00

Hi @Prateek Gupta,

In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,

Seeya
Prateek Gupta 5 Reputation points

2023-02-28T05:30:55.45+00:00

Hi @Seeya Xi-MSFT

I have referred to your solution - https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/

Unfortunately it didn't resolve my query.
Prateek Gupta 5 Reputation points

2023-02-28T05:55:27.3766667+00:00

Hi @Seeya Xi-MSFT

Good Day !
Apologies for delay in response.
I have referred to your solution - https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/
Unfortunately it didn't resolve my query.
My task is to load the data from SQL Server MDS Backend database which should result and reflect data to MDS Frontend UI (~ I have achieved this step), my main concern is I'm unable to achieve the last and the foremost step that is how to apply MDS Business Rule Validations step from SQL backend after data load in SQL Server MDS Backend database.

Let me know if anything is unclear.

Best regards,
Prateek

1 answer

Your answer

Seeya Xi-MSFT 16,571 Reputation points

2023-02-23T08:14:58.57+00:00

Hi @Prateek Gupta,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,

Seeya
Seeya Xi-MSFT 16,571 Reputation points

2023-02-24T05:49:28.7033333+00:00

Hi @Prateek Gupta,

In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,

Seeya
Prateek Gupta 5 Reputation points

2023-02-28T05:30:55.45+00:00

Hi @Seeya Xi-MSFT

I have referred to your solution - https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/

Unfortunately it didn't resolve my query.
Prateek Gupta 5 Reputation points

2023-02-28T05:55:27.3766667+00:00

Hi @Seeya Xi-MSFT

Good Day !
Apologies for delay in response.
I have referred to your solution - https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/
Unfortunately it didn't resolve my query.
My task is to load the data from SQL Server MDS Backend database which should result and reflect data to MDS Frontend UI (~ I have achieved this step), my main concern is I'm unable to achieve the last and the foremost step that is how to apply MDS Business Rule Validations step from SQL backend after data load in SQL Server MDS Backend database.

Let me know if anything is unclear.

Best regards,
Prateek

Answer 1

Seeya Xi-MSFT 16,571

Hi @Prateek Gupta,

Please refer to this blog:

https://www.mssqltips.com/sqlservertutorial/3808/sql-server-master-data-services-business-rules/

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Share via

How to apply MDS Business Rule Validations from SQL backend

1 answer

Your answer