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 "measures" or numbers associated with a...
Write back is usually used in applications that involve "what if" 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...
You need to find out if your tool has "time series" 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...
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.
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.