Browse by Tags
All Tags »
Dev (
RSS)
Whether you're doing demos, trying different aspects of applications or just looking for something new, you may want to have a broad and free selection of data to choose from. This post is here to help you out on that. I've collected a number of free data source for you to use: From the PowerPivot blog: Data on the District of Columbia http://ogdisdk.cloudapp.net/DataCatalog.aspx From Andrew Fryer 's blog: Data from the UK Government: http://data.gov.uk/data/ Datasets for neighborhoods...
Microsoft just announced SQL Server 2008 R2 release date and it’s May 2010 – not too far ahead… SQL Server 2008 R2 along with SharePoint 2010, Excel 2010, PowerPivot and Report Builder 3.0 are all strengthening Microsoft’s hold in the BI Market, covering more and more ground in aspects of Self Service BI and empowering the users. SQL Server 2008 R2 November CTP is still available for download and the development team is still interested in your feedback about it. Start the countdown…
I'm developing a report model in Report Builder 1.0 at the moment. I felt like it was finished and started testing the model with some sample reports I knew my client needed. And then I got the oddest thing… I would get a report saying something like: Gender Marital Status Amount of Sales NA NA 865 Male Single 30 Female Single 36 NA was what I chose to put in case I was using referential integrity. I was looking at the sales table and the employees table and if I found a sale which didn't...
I read a while ago in Chris Webb's blog about project Dallas which really got me interested. Quoting from the site itself: " Microsoft® Codename " Dallas " is a new service allowing developers and information workers to easily discover, purchase and manage premium data subscriptions in the Windows Azure platform. " So what does it mean? Basically that you have a public data source in the cloud that you can connect to and use for your own applications. And why am I so psyched...
I read a few months back a post by Robert Bruckner saying that the InScope function isn't relevant anymore, when you’re creating a report with Tablix . I remembered that when I wrote about a recursive sum for a group in a matrix in SSRS my example was only about SSRS 2005, as my VPC with SSRS 2008 crashed… well I finally downloaded SSRS 2008 R2 and installed it. So what did I do (after checking out the new maps feature)? Well, I wanted to see how simple creating a recursive sum in a matrix had...
Microsoft has released today SQL Server 2008 R2 CTP1 (formerly known as Kilimanjaro ) to the general public after it was available for two days already to TechNet and MSDN subscribers. Except for adding more features to help DBAs and developers work against the databases, SQL Server 2008 R2 CTP1also offers Report Builder 3.0. Yes, it’s true, you just blinked and already Microsoft has released a new version to Report Builder. The enhanced visualization from Dundas gages and charts is still there and...
Via Dan English ’s blog, I’ve learned that Pass is offering a day of BI webinars for free ! The Pass Convention itself is scheduled for November in Seattle. As this year there will no dedicated BI conference from Microsoft , Pass is the conference for you to get updated on all your BI needs. This is also why I was very happy to hear they’re also offering a day of free sessions with very well known speakers. The sessions are mostly SQL Server 2008 oriented, but I believe you’ll find more than enough...
A user of one of my projects had developed a very nice view in Panorama Nova View 5.5 and we decided to integrate it into the views for all the users. So how do we take a view that was saved in a personal book of a user and add it to the general book in Panorama? Well, first of all you take the user ID. Let's say it's "x123". You go to the Panorama Server and go to Program Files > Panorama > E - BI > Users > x123 > Private Book. You actually went to the physical folder...
A colleague of mine ran into a peculiar problem with her cube. She deployed it just fine and didn't get any error messages. Still, there was a problem. She could see the dimensions in her SSAS project just fine. She could see her cube as well. But she couldn't see any of her measure cubes. So what was the problem? She was missing the calculate statement from her cube. If you look in the BIDS at your cube on the Calculations tab with a Script View, you'll be able to see that the first...
I have recently built a data mart containing all the data of budgeting and accounting in SQL Server 2005 and created a Report Model in Report Builder for it. My users were looking for a flexible way to define different grouping on the data, without having to ask for my assistance. Defining new formulas in Report Builder isn't the most comfortable thing to do (specifically if they get complex and long), so we had to find another way. There was a suggestion of creating a view in the database with...
Recursive Sum for a Group in a Matrix in SSRS I wrote a post not too long ago about creating Sum for a Group with Recursion in SSRS . A reader of that post dropped me a line as she was having trouble recreating the same behavior in a matrix (the post itself had demonstrations in it only for a table). So I decided to look into how a recursive sum acts in a matrix, and boy what a learning experience that turned out to be... I created a report with a matrix which connected to Adventure Works DW. I defined...
Well I guess this means Panorama wants a bigger piece of the pie. In a very impressive and interesting webcast which was given Tuesday, March 31 st , Panorama showcased Nova View 6 RC1. So what are the promises given in the webcast and what was shown? Well for me, the biggest news was that from now on, Panorama Nova View will connect not just to cubes, but also to RDBMS – yes, a relational data source! And, you'll be able to create a dashboard which includes a report on both data sources. This...
Microsoft continues in helping you learn SQL Server 2008 , this time in collaboration with AppDev . You can download up to three hours of training. If you haven't used AppDev courses till now then you should know that they really walk you through the subject they're covering, also giving you an exam at the end of each part. It really makes for a great way to learn on whatever it is you're interested in. The courses offered are: SQL Server 2008 for Developers, SQL Server 2008: Installing...
רק למקרה ולא שמתם לב, נפתח בישראל Business Intelligence User Group – מקום שיכול להעשיר את כולנו ולעזור לנו ללמוד וללמד זה את זה נושאים ב BI . מעבר לכך, זה גם מקום מצוין להכיר ולשוחח עם עוד אנשים בתחום ואפילו לשמוע הצעות עבודה . אני מאוד מודה ל יוסי אלקיים , ערן שגיא ו רונן חן שבחרו לקחת על עצמם את האחריות שבהקמת הקבוצה וטיפוחה למען כולנו. אני עצמי הגעתי למפגש הקודם שבו איתי בראון העביר הרצאה מרתקת על Analysis Services Performance and Tuning והשכלתי רבות. ב מפגש הקרוב שיתקיים ביום רביעי הקרוב ירצה...
I created a Report Model based on a relational DB. I used the autogenerate option. I came to show it to my user, and he noticed that one of the attributes showed just the date, without any time. I looked at the field in my DB and saw that indeed it was of type DateTime and had data about time in it as well as the date. Looking at the format Report Model automatically gave the attribute, I saw the format was “d”. I remembered that usually I could copy the format I wanted for a field from the format...
More Posts
Next page »