We have a need to have data elements across various domains. Has anyone done this? What are impacts?
Yes, you can make Domain by query. However you need to maintain your domain all by yourself as they will not upgrade with clarity as OOTB domains will. So you need to analysis your requirement and if it can be fulfilled by CA Custom Domain then go with that else create a brand new domain and try to create that using tables and sub query taking care of cardinality and other rules.
Hi julian.kim ,
Yes it make sense to create domain by a query. We have a requirement of displaying the untouched time sheets (which has never been opened). Those type of time sheets does not have record in the database and not included in the OOTB domain.
I have developed a query and created a custom domain with the query. I have developed Ad hoc view using custom domain to display the untouched time sheets.
There should not be any bad impact due to the custom domain.
Best RegardsShubham Bhatia
Can't add Case statements to Domain Queries???
Interestingly, I am realizing Case statements don't allow me to get any data. When I create the query domains without the case statement, you can see the data. However, i get a new content error when i create a report based off a domain with a case statement