This may be issue because of cross domain. If your excel machine and cube server are in different network then you will get the same error. Try to work with...

Have you refreshed the data by processing the cube?

You can start SSAS from below listed sites:

http://www.learnmicrosoftbi.com/

This website contain lot of videos to learn SSAS basics. I found this website quite useful.

http://www.msbiconcepts.com/

This website has some good articles on...

Can you please go through below posts and check if you are missing something:

http://www.msbiconcepts.com/2010/10/implementation-of-proactive-caching-in.html

http://www.msbiconcepts.com/2010/10/proactive-caching-sql-server-2008.html

Please reply back if you are doing same as mentioned and still missing the data.

In SSAS DSV, create named View on this table and add one more column which has no time associated with timeadded column. Now you can use the new column to...

Hi miriyalasrihari,

This forum is for issues/queries related to SSAS. If you like to learn the tool, please refer SSAS books and MSDN documentation.

Please elaborate your issue with example.

You will have dimension surrogate key (say DSK) in dimension and same key will be in fact also. So if you join fact and dimension on the same DSK then...

Use linked cube feature if you are doing development. In MDX query, you can use lookupcube function. Here is one example,

-- LOOKUPCUBE( «Cube Name», «Numeric Expression»)

WITH MEMBER [Remote Measure...

You can capture MDX queries in profiler window.

If you are browsing data using excel then you can install OLAP plug-in which will help you to get MDX code.

http://www.msbiconcepts.com/2010/11/olap-pivottable-extensions-for-excel.html

By default, cube will be on MOLAP and

In one line, this is the best approach if

1) Your hardware supports the framework(CPU and m/y)

2) you don't need real time...

Please post specific error message.

use firstchild MDX function to achieve this.

You can create role at analysis services database level and assign access accordingly:

Roles access

1) Full control

2) Process database

3) Read definition

More details can be find in blog mentioned below:

http://www.msbiconcepts.com/2010/10/ssas-data-security-dimension-and-cell.html

By default, it will give only key column. You need add required columns in SSAS 2008 by editing dimension.