Notifications
Clear all
Topic starter
Does anyone have a report that pulls all of the following information?
The report is for: MNCM
Items Needed:
Patient Demographics (First & Last Name, DOB, Sex, Full Address, Phone# &
Language)
Appointment Physician
Physicians NPI
Physicians Speciality
Physicians Title
We have tried to create a report in Analytics; however, we could pull all but Physicians NPI & Patients Language. If anyone has anything that might help I would grately appriciated.
Thanks!!! Mary
Posted : July 16, 2012 11:55 pm
you will have to use Crystal to build this report, does Analytics give you access to the database?
Posted : July 19, 2012 12:53 am
Hi Mary,
Were you trying to accomplish this in Analytics using the OLAP Cube or a View as the datasource?
If you are using an Analytics View, it is possible to modify the sql to pull in the additional desired fields from the Centricity Database into Excel. I don't have time to provide you with code/instructions right now, but if you want to go this route let me know.
Unfortunately you cannot modify the "compiled" Analytics OLAP Cube to bring in additional fields.
Of course you can always use Crystal Reports as Arnold mentioned.
Thanks,
Allen
Posted : July 19, 2012 3:23 am
Topic starter
Thank you Arnold!
Allen- We are viewing as the datasource, and would love any information you have regarding this. I will be in the office tomorrow and all next week from 8:00am to 5:00pm CST. (218) 625-2718. If you would have an opportunity to call me. We are a GE hosted client, so i do not have access to our servers, would you solution require this?
Posted : July 19, 2012 5:44 am
hmm, I'm not that familiar with the hosted environment other than I know it's very "locked down". It might be worth a try, though. I'm guessing it would depend on a number of things including whether your Analytics database resides on the same server as your Centricity database and if your sql server is configured to allow queries to linked servers etc. etc..
Can you email ([email protected]) me the name of your Centricity database and the name of the View(s) you are wanting to enhance to include the new fields. I can test it including those fields on my end.
Posted : July 19, 2012 6:05 am
