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. rhoesche

    How traditional Relational Database differs from ROLAP?

    ROLAp uses relation structures to store multidimensional data. Generally, a star or Snowflake schemsa is used to accomplish this.<br>The fact table is the basis for the star. It contains a key to each of the dimension tables. It also contains the &quot;measures&quot; or numbers associated with a...
  2. rhoesche

    Writing to OLAP databases as well as reading from

    Write back is usually used in applications that involve &quot;what if&quot; analysis. I have written an number of budgeting applications using Essbase one of the OLAP tools. As long as all the possible data points have been created ahead of time write back works nicely. It also allows imput of...
  3. rhoesche

    Aggregate Fact Tables ?

    You need to find out if your tool has &quot;time series&quot; functionality. Both Essbase and OLAP Services have this functionality. What these functions allow you to do is to create a first, last or average or sum value on the time dimension. Using last would result in the following. Jan 10...
  4. rhoesche

    Need Help publishing an Microsoft OLAP cube to Intranet

    Get evaluuation software from one of the 10 -15 software companies that support MSOLAP. Business objects, Brio, Temptec, and others. See the MS web site for partners.
  5. rhoesche

    Clickstream: ROLAP or MOLAP?

    Look at hyperion they are comming out with click stream applications on top of Essbase a MOLAP databasse. If you can summerize your data a little it should work fine. The new attribute dimensions would allow even greater analysis of you individual users data.
  6. rhoesche

    Tricky Time Dimension Problem (Need expert's opinion)

    The time dimension in OLAP is used to identify one element of of the data. If you have two time fields it is easiest to to pick one as the identifier of time. I would probably pick orgin as the value. The second field should be a regular dimension. However, if you wish to see months, years etc...

Part and Inventory Search

Back
Top