is it possible to access database view created in another scope to be available in the list of fact table field in indicator source

harshita20
Kilo Contributor

find_real_file.png

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Harshita,

I just tried this and here are the observations:

I don't think you can access the database views as facts table if the scope is different.

1) Database View in Custom scope

a) when trying to create indicator source in Global scope I was not able to search this database view as Facts table

2) Database view in Custom scope

a) when trying to create indicator source in custom scope I was able to search database view in Facts table

I believe you can only access those database views in Facts table that are in same scope as in Indicator source.

Since database view is not a table actually in sys_db_object Table you cannot set the Application Access Settings.

Even I tried creating cross scope privilege record but it didn't work for case 1.

If found anything will mention here later on.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

5 REPLIES 5

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Harshita,

There are few restrictions when it comes to application scopes https://docs.servicenow.com/bundle/orlando-application-development/page/build/applications/reference... . That said try to check "Allow configuration" checkbox to true for table in another scope via application access setting and check once https://docs.servicenow.com/bundle/orlando-application-development/page/build/applications/concept/c...

 

- Pradeep Sharma

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Harshita,

I just tried this and here are the observations:

I don't think you can access the database views as facts table if the scope is different.

1) Database View in Custom scope

a) when trying to create indicator source in Global scope I was not able to search this database view as Facts table

2) Database view in Custom scope

a) when trying to create indicator source in custom scope I was able to search database view in Facts table

I believe you can only access those database views in Facts table that are in same scope as in Indicator source.

Since database view is not a table actually in sys_db_object Table you cannot set the Application Access Settings.

Even I tried creating cross scope privilege record but it didn't work for case 1.

If found anything will mention here later on.

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/performance-...

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi @Ankur Bawiskar ,

FYI - this is considered bad form in the community. It comes off as "begging for points". The focus should be on the person you are helping, not on you. 🙂 

find_real_file.png

P. S: I think Chuck already mentioned this to you in other thread 2 weeks back https://community.servicenow.com/community?id=community_question&sys_id=c56a7fb0db3dd8d0414eeeb5ca96...

 

Thanks,

Pradeep Sharma

@Pradeep Sharma 

Thanks for informing. I have updated the comment. will try to keep that in mind.

But I could see many community members following the similar things adding footer etc. Not sure whether the best practice is being followed by other members. If there is some rule it should be applicable to every community member.

Regards
Ankur

 

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader