I have what is to me a bit of a tricky design issue in my SSAS cube. The question is related to general accounting practices, I have a fact table containing financial transactions (i.e. a ledger) and each of those transactions is tagged with a transaction date and a period. The period does NOT related directly to a day, or a series of ...
Can any one recommend any good primer books / resources on business intelligence and reporting using the Microsoft stack? As a business we currently use crude static Crystal Reports for our reporting needs but looking to overhaul it with a proper scalable BI stack that allows internal and customer facing reporting, analytics and KPIs....
I'm trying to let my users connect to OLAP cube in SSAS 2005 using Excel 2007 over the Internet. I've set up dynamic security using fact table in cube. It uses UserName function, so users should authenticate to SSAS using windows accounts. I've set up msmdpump.dll component on IIS, allowing windows authentication, but not anonimous one....
What is the best references/links,cheatsheets for the MDX language? Here are a few starters that I have collected. Please share yours :) http://www.gumper.com/mdx.html http://www.sqlserveranalysisservices.com/OLAPPapers/InventoryManagement%20in%20AS2005v2.htm http://www.ssas-info.com/ssas-cheat-sheets/72-cheat-sheets/880-time-mdx-cheat...
Hi, I'm looking for a good book that about Microsoft Business Intelligence Development Studio 2005. Most interest goes to SSIS, but SSAS and SSRS are also important. The book explains in a fair, simple and as much hands on way how the Development Studio for BI works (solution, projects, do's and dont's) and all the transformations in S...
Is there a way to develop Bi (Business Intelligence) solutions with Django? Therefore it should be possible to define models with more than one Datasource. Is anybody out there who has experienced BI with Django? How could it work ? ...
When you look at the Business Intelligence arena, there are many big players, including SAS. In my time in this space I am noticing more big players moving to a more user friendly tool that doesn't require coding skill sets. Also, I am aware that SAS is trying to protect their market share by introducing tools that are more point and c...
I am just starting to create our Business Data Catalog(s) for our practice management system and I am running into an issue w/ our staff table. Background: I am using Business Data Catalog Definition Editor to create my ADF. I am using the RevertToSelf Authentication Mode. I have tried a few other tables and they seem to work just...
Hi, anybody have used Jitterbit as an ETL tool? any reviews/tutorials? ...
I want to change it from one database to another. There don't appear to be any options to do this on the pivot table context menu ...
How does Informatica handle unstructured data sources like PDF. If a tabular report is stored as a PDF, can we read it out from PDF as a tabular data (like a data table in .net)? ...
In Short I am thoroughly confused by the array of SQL Server services available, and am having a hard time finding a brief primer. The Scoop I am a long time ASP.Net developer who has happily been churning out ASP.Net applications for years. These have usually been based on SQL server and a range of custom tables and views. Just re...
I have to build an analytic dashboard with Excel, and would like to know whether there is any chart library you would recommend. The charts should be attractive and easy to use by standard users. I've tried Microcharts, and they look very promising, but I'd like to evaluate more options before reaching a decision. Thanks a lot. ...
Background I have a dimension table that has a single record for each day. Each record has a primary key so example data would be: Dimension Table --------------- --------------------------------- | ID | DateTime | --------------------------------- | 1083 | 04/10/2008 10:02:00 PM | --------------------------------- ...
I'm designing the Fact and Dimension tables for a data warehouse currently using SQL Server, SSIS, and SSAS. Will I get any real benefit from programming the relationships between the dimensions and the fact tables into SQL? Or am I better off just defining the relationships manually when it comes time to create the cubes? It seems to b...
I'm working on a data warehouse project and would like to know how to (preferably in a Derived Column component in a Data flow) strip the date piece off of a SQL datetime record. Once I have the datetime converted to just a time I am going to do a lookup on the time to find the related time record in a time dimension table. Can someone...
Hi I'm a little confused on how to connect BI with data mining. Can BI be termed as some kind of a manifestation of data mining? How different is a BI tool like Microsoft Analysis Services from a data mining tool like Weka? I guess BI involves more of reporting and analysis of data, where in the data undergoes some kind of aggregatio...
Hopefully this is easy to explain, but I have a lookup transformation in one of my SSIS packages. I am using it to lookup the id for an emplouyee record in a dimension table. However my problem is that some of the source data has employee names in all capitals (ex: CHERRERA) and the comparison data im using is all lower case (ex: cherrer...
Hello, I am a n00b on WebI. Could somebody please tell me how to do alternate row shading in a BO CrossTab. Thanks ...
We have a report that in 2005 version of SSRS, we could dynamically update one parameter (which is a text box) from another report parameter (which is a drop down). Each time the drop down changes, the text box would update. No problem. Now in 2008, it only happens when we first preview the report (in other words, the text box is upda...