I have created in CA Service Desk the alias that allow me to bring the name of the access type
The created alias was added as a dimension through the universe designer. Being available for use in SAP BusinessObjects 4.1 Support Pack 3
When I run the query it shows me only the contacts that have an access type assigned.Does not show me the ones that do not have an access type assigned.
For your help from now on thank you very much
Did you try by keeping a query filter.
Like "Access type is Null" or "Access type not in "existing list of access types""
as this relates to Service Desk rather than BSI, I've updated the Categories for you - that should get you a bit more visibility.
DearThe information is obtained from SDM However the reports are generated in BSI
Thanks - I've added it back, now.
So these are Business Service Insight reports, rather than CABI ones? How are you collecting the access type in the resource? This will dictate how the metrics are grouped in the contract.
I think the query is doing an 'Inner Join' behind the scenes. So try to edit the join to 'Left Join' or 'Right Join' and see if the results change?