Search results for query: *

The company I work for deals with post-analytics... as I'm sure the vast majority of the analytics market does. We get data that is at least a day old, add it an existing OLAP Cube, then processs... then we look at that cube for analysis. However, I was recently asked if BI had a real-time...

Hi guys. If I am posting this in the wrong forum, please let me know. I am looking for a pivot-table type control, similar to the one used by Excel 2007 OLAP Client, that would allow me to use to connect to an OLAP Cube. Does anyone have any suggestions? Thanks in advance.

Hi guys. If I am posting this in the wrong forum, please let me know. I am looking for a pivot-table type control, similar to the one used by Excel 2007 OLAP Client, that would allow me to use to connect to an OLAP Cube. Does anyone have any suggestions? Thanks in advance.

So here's the scenario: Say I have the following MDX Script SELECT [Measures].[Sales] ON COLUMNS, [DIM VEHICLE].[CARS].CURRENTMEMBER ON ROWS FROM [SALES_CUBE] But then my boss comes in and says, "Hey GrandMauler... we need the results put into terms of Corvettes and Non-Corvettes!" How do I...

I'm using SSRS 2005. I'm designing a report that will show week over week trends. These week columns will obviously be in my column group. However, the first column needs to be independent of the weekly column group. It will show some sort of percentage for the current week and does not need...

This year, I managed to convince my bosses to invest in a BI platform. We purchased SQL 2k5, two high-end servers, and Proclarity Desktop proffesional. I have built a Cube for one of our clients and showed them how to access it via an Excel OLAP client. I built a very sophisticated SSIS pkg to...

Ok, some time ago, when I was first researching Reporting Services, I came across a tutorial that showed how to use an MDX data source. I remember the tutorial used a window different from the one on the data tab in Reporting Services platform. It wasn't the Design Mode window. I have...

This one is pretty staightforward: Here's the part of the code that fails: Dim oServer As New Microsoft.AnalysisServices.Server oServer.Connect("MyServer") Here's what you need to know: MyServer was removed from our company's domain and put on a separate network for security reasons. There...

So I've managed to deploy a Report Server. And I've played aroudn with the Report Builder, which is a very cool ad-hoc reporting tool. But now I want to make Report Builder available to other users. I've created the roles for the specific users I want. I've given them "Content Manager"...

I've created my report using BIDS and am ready to deploy it. When I try to deploy it, I get a prompt for Logon and Password. When I input both, it prompts me again, suggesting it is rejecting my logon and password. I've already confirmed that I have Admin permission for both the OS and SQL...

I'm trying to generate a report model. The first step is to create a Data Source in Report Server. However, once created, I right-click the source and it wont allow me to "Generate Model..." I've double check the connection string and it seems good: Provider=MSOLAP.3;Data...

Ok, I have a senior manager making a push to a Vertica Database. I have never heard of this database. I did a Wiki lookup and, while it does look prominsing in its querying speed, I'm not sure how compatible it would be with things like OLE Db connections and .NET assemblies. If anybody has...

Hello. Here's the set up: I am running an SSIS pkg (SQL 2k5) on a x64 machine. The goal is for the pkg to run via an SQL Agent Job so that others can run it as well. The pkg accesses an Excel file, which means it cannot run under the SSIS subsystem, but must instead run in the Operating...

When I save a copy of the IS Package to the MSSQL Environment, as a package on the IS server, and someone other than me tries to run it, they get the following message: I've tried different things, like change the Protection Level to "Rely on Server Storage and roles for access control", but...

Hello. Some time ago, I wrote a VB.NET/SQL application for a Telecom company that basically looks up call routes and displays the specifics of the given route on the GUI. For a call routes, there are many specifics to display... mainly the type of tariffs applied to a route. Depending on the...

I'm writting an IS package that stages the data in such a way that a new fact table is created per week of data. However, I don't know how to tell the cube processing object in the package to dynamically create a new partition for the cube. I'm guessing I need to write some DDL that inserts...

I'm trying to run an IS package that has an FTP component. While it runs fine in Debug mode, when I deploy the package and try to run it an scheduled job, it fails with the following message: DTS: PROPERTY - "Key not valid for use in specified state" I take this to mean that the username and...

Hello, I'm not sure what forum to post this in. If this is the wrong one, please tell me. The reason I'm posting this in this forum is because I'm writting an SSIS Package that executes a Process Task that unzips a gz file using 7z. The package works fine in an x86, but errors out in an x64...

Is there a way to drop all the indices on a table without having to specifically name them? This an MSSQL 2000 question.

Hi. I'm attempting to attach an SQL 2k5 mdf and ldf DB (SET TO SQL 2000 COMPATIBILITY) and I keep getting the following message: "Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes." I've tried everything I know of with no avail...