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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Avg function compared to Essbase avg function
I have an Avg formula in an Essbase member. I am trying to replicate this in MSAS. Essbase formula avg(expList) expList can be any member that returns a number, whether the list is of members from the same dimension or not myavg = avg(Jan:Mar,LA) Jan:Mar is the set Jan,Feb,Mar from my Time...- Hurdles
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Analysis Svr Member Properties
I have a member, it has a Member Property. How do I use an MDX stmt to get to that member property. I have Time dimension. Jan, Feb, Mar etc. I built a Member Property = "Alias", that is J, F, M etc. I looked in some books for the way to get hold of the property shows... -
OLAP Cube Update
I have built a cube using SQL Tables as the datasource. Is it possible to update the cube using a flat file (something other than updating SQL tables) I have it configured as a MOLAP, and do not want it to be ROLAP. As comparison, Hyperion Essbase is true MOLAP, you can build cube and update... -
Crystal 6 and MS OLAP
I created a VB App that uses ADOMD and MDX that generates a query from a cube in MS OLAP and puts it into a VB DataGrid. I want to hit a button to generate a report from the result set. 1. Can I generate a Crystal report directly from the DataGrid or 2. Can Crystal 6.0 access a MS OLAP...- Hurdles
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
