Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. eric102269

    Analysis Services level member formatting question

    Hello. If I create a dimension with 3 levels, can I define or change the formatting so that the members for each level appear differently when a report is created? I want to use formatting to increase the readability of reports. For example: Cars dimension Make Model Color Is there...
  2. eric102269

    Front end tools to access MS Analysis Server cubes

    Anybody use/know anything about the Crystal Reports for OLAP tool?
  3. eric102269

    Front end tools to access MS Analysis Server cubes

    If you can wait a bit, you can request an eval copy from proclarity. It comes snail mail in about a week.
  4. eric102269

    Front end tool to access MS Analysis Server cubes

    Hello. I currently have a small data warehouse on Windows 2k/SQL 2k. I am using Business Object's BusinessQuery MD (formerly OLAP@WORK). This tool has been a maintenance nightmare and I need to find alternatives. Here is the question: Are there any other tools that will allow access to MS...
  5. eric102269

    Front end tools to access MS Analysis Server cubes

    Hello. I currently have a small data warehouse on Windows 2k/SQL 2k. I am using Business Object's BusinessQuery MD (formerly OLAP@WORK) This tool has been a maintenance nightmare and I need to find alternatives. Here is the question: Are there any other tools that will allow access to MS...
  6. eric102269

    Informatica PowerMart migrations between different servers

    Hello. Informatica PowerMart v4.7 question: I am looking for a way to move or migrate transformation changes from my informatica PowerMart repository on the development server to the QA server. How can I do this? The repository is on MS SQL Server 7.0. Thanks in advance. Eric
  7. eric102269

    Moving MS OLAP Services cubes from one server to another

    Hello. The server that holds my data warehouse is being upgraded to a new machine and I would like to move a bunch of cubes to the new server. I am running MS SQL Server 7.0 sp2 w/OLAP Services sp2. I am looking for options. I am hoping that it is as simple as using ftp to move the cube's...
  8. eric102269

    Replication question

    I have a SQL Server 7.0 database that is using transactional replication to move updates to a data warehouse database for reporting. This may be easy, but I am not a DBA. Here is the question: If there are ever schema changes to the source database, how can I (if it is possible at all) cause...
  9. eric102269

    Data Cleansing

    Data Cleansing/Scrubbing I have just been given the task of cleansing an MS SQL Server 7 data warehouse. Question: Are there any good books, white papers, docs, etc that can help me figure out where to start? Other resources? I have found info on 'why' you should, but not on 'how'...

Part and Inventory Search

Back
Top