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 derfloh 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. dmcmunn

    Agile Data Warehousing?

    johnherman and Hans63, First, thank you very much for your very thoughtful responses. This is just the sort of dialogue I would like to pursue. I would suggest that getting agreement on requirements well in advance of the development cycle is nearly impossible in all but the simplest of...
  2. dmcmunn

    Agile Data Warehousing?

    Hans63, I have read the ETL book from the Kimball Group and the MS DW Toolkit as well. Both very helpful reference guides for practitioners. I believe many of the agile software development tenets such as: (1) short(2-4 Week), regular time periods between deliverables, (2) initial broad...
  3. dmcmunn

    What is Datawarehouse 3.0?

    Sad to say, but most of my Fortune 500 engagements are barely DW 1.0, much less 3.0.
  4. dmcmunn

    Agile Data Warehousing?

    Given the "almost chaos" level complexity of building business intelligence enabled enterprise data warehouses in today's world of rapidly changing multi-organization, multi-merger/acquisition, multi-national, multi-lingual corporate world, what are some agile methodologies or practices...
  5. dmcmunn

    Time/Date Dimension, Surrogate Key or not

    If you need a pre-populated Kimball-style date dimension source and the SQL/code used to build it (at least in SQL Server) give my freeware date dimension toolkit a look. http://www.ipcdesigns.com/dim_date/ Be sure to send a comment. Best regards, Don
  6. dmcmunn

    Data warehouse staging design

    The ETL Toolkit is in fact has a great overview on architecture with some suggestions on metadata that should be kept as data moves from the market (sources) through the kitchen (ETL processing) to the table (reporting). I will be publishing my perspective on these data structures over my...
  7. dmcmunn

    What is data profiling?

    Please check out my *FREEWARE* data profiling toolkit at: http://www.ipcdesigns.com/data_profiling/index.html No registration required. Please be sure to leave a comment. Data profiling ("DP") is a methodology of deriving metadata about a given data attribute which can range from the...
  8. dmcmunn

    DW and "what if" questions

    historical trend analysis is great for relatively static systems (home loans, major appliance orders, banking) because those systems change incrementally. Where they fail and breakdown totally is in finding order in highly dynamic ("chaotic") systems, such as weather, stock market, massively...
  9. dmcmunn

    Documenting data warehouse

    tannu65, Barring obtaining the rationale and/or design documentation from the original data warehouse architects (there was at least 1 somewhere, right!) as Hans63 suggested, I would recommend constructing a little data profiling information for each column in each table. This can be automated...
  10. dmcmunn

    SSIS on 64-bit platforms

    You have what are called "VBScript components" which you can use in numerous ways to manipulate and configure other SSIS components or perform processing at runtime or even on events. However, the language used by "VBScript components" is VB.NET, not VBScript as in classic ASP, VBScript or VB...
  11. dmcmunn

    SSIS on 64-bit platforms

    Here is a code snippet to make the Lookup component perform a bit better... Imports System Imports System.Data Imports System.Math Imports System.Xml Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Imports System.Data.SqlClient Imports...
  12. dmcmunn

    SSIS on 64-bit platforms

    For those of you moving to the wonderful world of 64-bit SQL Server 2005 and SSIS. I want to share a few of the items I have learned along the way. 1. First, make sure your 64-bit SQL 2005 is updates with SP1 and all the hotfixes for SSIS _BEFORE_ deployment of your packages and definitely...
  13. dmcmunn

    Finding object's folder name MSTR 8.x web ???

    Had to do with a permissions issue on a folder in between the highest and lowest folder containing the report.
  14. dmcmunn

    Enterprise Manager IS_REP_SQL_LENGTH

    I would guess the SQL could not be generated due to an error.
  15. dmcmunn

    Multiple Calendars?

    Has anyone architected a project with multiple calendars in the same project? Some of my team's challenge for a supply chain effort is being able to map calendars from different suppliers into the internal distributor's Gregorian/fiscal calendar for purposes of performance comparison. Each...
  16. dmcmunn

    Finding object's folder name MSTR 8.x web ???

    When I search for a report object in MicroStrategy 8.x web client, the resulting hits provide links to the highest level folder, but not the sub-folder which actually contains the report. Is there a web/client preference or other setting which will provide the fully qualified path to the...
  17. dmcmunn

    Ignoring attribute in report heading for other attributes below

    entaroadun, I'll give it a shot after I get this to production. Thanks, dmcmunn
  18. dmcmunn

    Select statement in Join condition

    Example... Assuming the following minimal data structures... addresstable b nametable a b.dateid a.dateid b.address a.name b.dateid b.address a.dateid a.name 1 Address1 3 name3 2 Address2 2 name2 3 Address3 4 Address4 5 Address5 Assuming this is your desired result...
  19. dmcmunn

    Object Prompt and Alias in Report Data Options

    Seems like a strange requirement to me. Why not just rename the existing attributes ? This solution is a hack, but you could duplicate your 8 attributes and make their names something more displayable. Or if more obfuscation is required, use names like "ATTR1", "ATTR2", "ATTR3". Best...
  20. dmcmunn

    Ignoring attribute in report heading for other attributes below

    entaroadun, Almost... I am using a pre-pass report filter to select the list of Prov's for the report. For a Prov to be included on the final report, it must have had a positive value for either of the two metrics: Qty1 or Qty2 for the Org selected during Time Period selected. Qty1 is...

Part and Inventory Search

Back
Top