Twitter: @MikeDavisSQL
Mike Davis, MCTS, MCITP, is a Senior BI consultant at Pragmatic Works. He is an author of a few Business intelligence books. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, and SQL Saturday events. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
You can also find me on Bidn.com/blogs/mikedavis
MikeDavisSQL 
Hi Mike,
I had registered for your webinar today. But had technical problems and could not attend that. Will you be holding another webinar on cubes?
If yes, I will be interested.
Thanks
Amrita
I will be doing lots of webinars at pragmaticworks.com. You can also watch all of the past webinars there too.
Hello Mike ,
I am having trouble with importing data from an Oracle database and i know the issue is a date field in the table. Some of the dates are actually dummy dates ie ex: 1/1/9999 but that is valid in the business the company is in . I cannot drop that field ,so can you suggest a work around. I have tried importing it into Access and it works fine , but when i refresh my Access DB , it blows up and wont refresh my power pivot any more . Please suggest what can be done .
You will have to change the date to a valid SQL date. Like 1/1/2999
Thanks Mike, that was very helpful!!
Mike i am having an issue trying to bring data from two tables in power pivot data model into the pivot table .Below is the query and i have both the tables in my data model with almost all the fields present in the DW. What am i doing wrong .
select SUM(a.number_ac_qy),SUM(a.number_hp_qy),SUM(a.number_hs_qy),SUM(a.number_pp_qy),SUM(a.number_ps_qy)
FROM lmis_account_profile a,
lmis_bill_authorization b
WHERE b.account_no =a.account_no
AND b.bill_authorization_credit_dt>=’01-JAN-2013′
AND b.bill_authorization_status_cd =’C’
Not sure I under stand the issue. Try posting this on the forum on BIDN.com so you get more people responding.