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

Go to solution
harshita20
Kilo Contributor

‎07-10-2020 04:10 AM

find_real_file.png

Preview file
48 KB
0 Helpfuls
  • 2,288 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

‎07-12-2020 02:52 AM

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

0 Helpfuls
5 REPLIES 5

Go to solution
Pradeep Sharma
ServiceNow Employee
ServiceNow Employee
In response to Ankur Bawiskar

‎07-12-2020 09:31 AM

I am sure you will agree there are few best practices (ex: creating duplicate profile, copying the same response, etc..) which are not followed by very **few** members. Again this is something community team is aware of it and they are working hard to fix this things in the future. Thank you.

 

- Pradeep Sharma

0 Helpfuls