Hello,
I’m having a problem where Custom Field data is not getting transferred over to SQL database. Here’s what i have done,
1. Relations for Facts
2. Custom Attributes for Facts
3. Access View
4. Data Source
5. Deploy to SQL Server Db
6. Data Load Run
7. FACT_BUSINESS_OPP_BI_TAB table shows as NULL for CF$_EC_NEXT_STEP
8. Querying for ‘SELECT * FROM FACT_BUSINESS_OPP_BI’ shows below,
Any idea why it’s not transferring any custom field data to SQL Server?
Hi
This could be due to a row level security (RLS) issue. We extract data through IFSINFO user. Login to the DB using IFSINFO user and query the BI view. If you don’t see data there then the issue is with RLS.
That means IFSINFO user doesn’t have access to data in that particular column.
Check if there are any security checks in the BUSINESS_OPPORTUNITY_CFV view.
Eg: Site or Company access checks
Hi
The issue was with RLS like you mentioned. The view BUSINESS_OPPORTUNITY was referring to the Users per company. Once i added IFSINFO to the company, i was able to see data using IFSINFO user. Also, custom field data is now transferring to the SQL Server table without any issues.
Thank you very much for you help!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.