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!

  • 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. JerrySmith123

    Sample Excel VBA code to extract from SAP Table

    Go to http://www.sappro.com/downloadFrame.html. Drill into 2002. Look for the words "automation". You can download some stuff. Not much but it's something. Here's something http://www.tek-tips.com/gviewthread.cfm/lev2/78/lev3/80/pid/649/qid/456645 And something from the HELP...
  2. JerrySmith123

    Cognos Series 7.1

    We just downloaded it and installed it on our Dev server. 1) The Upfront is VERY different. Has drag and drop capability MUCH like powerplay. They are essentially putting all efforts into expanding on the Upfront experience/ thin client rather than Powerplay windows client environment. This...
  3. JerrySmith123

    Dimensions, facts and a classical example

    1) Record the return. If you are dealing with an ERP system like SAP it has it's own order type... A return is basically a reverse sale. You want to capture it in your fact table because you (should) want to do analysis on WHY customers are returning your product, how often, etc. Is is always...
  4. JerrySmith123

    effect of deleting categories

    One way to test whether you'll lose them after cleaning house is to just save you PYI or MDL as something else (like test.pyi)...do the clean house, look at the categories through the category viewer icon, then generate categories from your source and look at the categories again. Did they...
  5. JerrySmith123

    Price - measure or dimension

    You can set the measure to aggregate the average of all the granular prices... this doesn't exactly exclude it - but does cause the aggregation to make a little more sense. The other thing you can do is to show at the summary levels the "Lowest" price or the "Highest&quot...
  6. JerrySmith123

    CDHDR and CDPOS tables

    No. To the best of my knowledge only those objects that have been designated (by default) to capture changes, and those that have been specifically configured to create change documents are captured in CDHDR and CDPOS.

Part and Inventory Search

Back
Top