Did you know that when you’re using a PivotTable connected to a Cube in Excel, that you also have the ability to see the MDX being used behind the scenes? Below I will show you a few quick steps on how to do this. As you can see in the example below cell C3 has a value of $1,255.08. Take a look at the formula as well and you will notice the same value of $1,255.08. In order to see the MDX, highlight the cells you want to see and go to the PivotTable Tools ribbon/OLAP Tools/ Convert to Formulas. ...
Read More
Hello BIDN, Let me first thank all of the 50+ attendee’s attending my SQL Lunch session were we discussed the different types of containers available to you in SSIS. Also thanks to the guys running SQL Lunch for giving me the opportunity to speak as well. As promised here are the sample packages that we went through yesterday, click here . I hope you were able to learn something new in yesterday’s session. Stay tuned because as requested in yesterday’s session I will be doing another more advanc...