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 Rhinorhino 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: *

  • Users: MDXer
  • Content: Threads
  • Order by date
  1. MDXer

    Creating Tabled on the Default File Group.

    I'm hoping someone out there can shed some light on this issue. Not after a solution as we have the process working but looking for insight on why this occurs. I have a SQL 2005 SSIS (this is not an issue with SSIS but rather in the underlying SQL Database) process that extracts data based on...
  2. MDXer

    Package Configurations

    Good read on Package configs. SSIS: Parent package configurations. Yay or nay? Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck
  3. MDXer

    BIDS Helper

    This has a nice set of add ins for SSIS and SSAS. I recomend getting the latest code and compiling it yourself as it has more features than the last compiled release. Bids Helper I am also posting this link in the SSIS forum as it has a number of features that are targeted at SSIS and some...
  4. MDXer

    BIDS Helper

    This has a nice set of add ins for SSIS and SSAS. I recomend getting the latest code and compiling it yourself as it has more features than the last compiled release. Some of the tools address the GUID issue we have probably all encountered when using a template package along with better...
  5. MDXer

    DefaultBufferMaxRows/DefaultBufferSize

    Bit of a debate going on regarding these 2 values. My understanding of this has been that SSIS will look at these 2 values and then makes an analysis of the dataflow to determine how the average size of a row in the dataflow ad how many rows it can fit within the 10MB (if you leave the...
  6. MDXer

    70-446

    I know MrDenny has taken and passed the MS 70-446 exam and was wondering if he or anyone else can give me some insight into it. I have transcenders being order but curious how it compares to 70-445. Paul --------------------------------------- Shoot Me! Shoot Me NOW...
  7. MDXer

    070-445 BI Implementation and Maint.

    If you are thinking about taking this test and haven't been working in al areas of BI for years all I can say is STUDY. this test covers the following: SSAS SSIS SSRS Data Mining both admin and dev aspests. It has to be the most insane certification test ever. Paul...
  8. MDXer

    Cascading Prompt or Hidden Parameter

    SSRS 2005 SSAS 2005 I Have a report that uses a SSAS 2005 Cube as it's data source. I have to add 2 prompts with One of the prompt values being based upon the value of the other prompt. In my cube I have [Date Dimension].[Fiscal MMMYY] which is the basis of the filters. THe need is for...
  9. MDXer

    Integration Services: Performance Tuning Techniques

    I found this helpful in better understanding when,why and how to do somethings in SSIS. Integration Services: Performance Tuning Techniques Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck
  10. MDXer

    SSAS 2005 Organize Calculations

    Has anyone come across and efficient method to organize calculations within the Meausres. The issue is pretty simple. I have a cube with 45 Measures of which there are approximately 15 various calculations that users want/need to be able to see each measure by Items like YTD Prior YTD and...
  11. MDXer

    OLAP Design Best Practices for Analysis Services 2005

    Not sure how many of you may have seen this already. OLAP Design Best Practices for Analysis Services 2005 Paul --------------------------------------- Shoot Me! Shoot Me NOW!!! - Daffy Duck
  12. MDXer

    Sequence Containers ISSUE

    Background: Process is ETL for a data warehouse. Design is multiple SSIS packages, 1 package per process task (ie Package for Patron Dimension load, package for Fact table load etc). I control the execution and order of execution, obviously dimensions process prior to fact tables, through a...
  13. MDXer

    Unused Records

    I have a SSIS package, part of a data warehouse ETL, that Reads in from 2 source tables approx. src 1 = 350K rows. src 2 = 120K rows This are both sorted in the extrat and then merged together in a Left outer Join (merge join task). Based on specific column conditions in a conditional split...
  14. MDXer

    Export to PDF inserting blank Pages

    I have report that has # charts and 2 matrix grids. Each of these is within a seperate List container to allow the graphs to generate based upon the groupngs. The issue I am having is that when exporting to PDF for every page that has a graph or grid the next page is blank. I have gone...
  15. MDXer

    SSAS 2005

    I sent a request a couple months ago about the SSAS 2005 getting it's own group since the difference between the 2 is extensive. Maybe if others do as well we may see it as a group like we did with SSIS. Shoot Me! Shoot Me NOW!!! - Daffy Duck
  16. MDXer

    Project Real Documentation

    A must read for anyone developing BI using SQL2005 toolset Project Real. There a significant differences between AS2K and SSAS 2005 that make design and development different between the two products. Shoot Me! Shoot Me NOW!!! - Daffy Duck
  17. MDXer

    Restore help please

    Let me start by stating, this is my first time working with oracle. I have a client who has provided me with what appears to be a file backup of one of their source systems. The backup contains multiple directories and files Directories include ARCHIVE LOGS, Findata, database control file...
  18. MDXer

    Experience

    Recent thread got me thinking on the information being passed in this forum. So I thought it would be intresting to see what peoples experience and opinions are regarding MSAS. Shoot Me! Shoot Me NOW!!! - Daffy Duck
  19. MDXer

    Killed process

    I had a process that I had to kill. The process had ran over night and didn't seem to be progressing. I used the KILL <<SPID>> to end the process. I know and expected the spid to then enter a KILLED\ROLLBACK status. However when I check the state of the rollback with KILL <<SPID>> WITH...
  20. MDXer

    Avoid Child Package version conflicts

    I know this issue has hit me more than once. While researching another issue I was having I came across a tip somehwere (sorry read so many resources I don't remember), that had an excellent solution to the problem of an execute_package_task being mapped to an older version after you have...

Part and Inventory Search

Back
Top