Top "Olap-cube" questions

Data Warehouse vs. OLAP Cube?

Can anyone explain what is really distinction between Data Warehouse and OLAP Cubes? Are they different approach for same thing? …

data-warehouse olap olap-cube

Get SSAS cube last process time

In Excel I make an Analysis Services connection to a data cube. I would like to be able to show …

sql excel vba ssas olap-cube

Difference between hierarchy and levels

I have just started working on Mondrian. I am having a hard time understanding hierarchies and levels. What is Difference …

business-intelligence olap-cube mondrian

How to automatically refresh sql server olap cube

I have built a cube in visual studio and deployed to SSAS. How can I get the data refreshed using …

sql-server olap-cube

alternatives to jpivot?

JPivot, even with all it's functionality, seems a bit outdated... last version at http://sourceforge.net/projects/jpivot/ is from 2008…

ria data-warehouse business-intelligence olap-cube

A connection cannot be made. Ensure that the server is running

When I am trying to process dimensions after creating a data source view I get the error: The project could …

olap-cube sql-server-2012-express sqlbrowser

Filtering MDX query with current year & month using Now()

How can I filter data in MDX with current Year & Month? What I did so far is: WHERE strtomember{ […

ssas mdx olap-cube ssas-2008

Why to build a SSAS Cube?

I was just searching for the best explanations and reasons to build a OLAP Cube from Relational Data. Is that …

sql-server-2008-r2 ssas cube olap-cube

Calculate database size in Oracle Essbase

Classical question at tests: I have 4 dimensions: Markets: Sparse, 10 stored members, 10 total members Products: Sparse, 5 stored members, 7 total members Accounts: …

olap olap-cube essbase

MDX Column Alias for use in SQL

I'm trying to query our SSAS cubes and return the values into a SQL view for use as parameters in …

sql tsql ssas mdx olap-cube