Cant show anything in the AS's Cube Data Explorer

Hi, I was killed by one strange problem:

I made an OLAP Project in the BusinessIntelegent Studio, with right Dims, right cubes, right measures,and built it successfully. I put some data into the it's fact table and dimention tables in the SQL server, and ProcessFull the cube successfully.

From the Process Form's result record, it said that i have read 25000 rows into the AS cube.

I get to the BusinessIntelegent Studio's Cube Data Explorer, i mean the place just to explore the cube's data in a pivot table tool. I put any of the measures into the tool, but it always shows nothing(Empty). I sent a MDX to the server to select the same measure, and also got nothing (NULL).

Any friends have met this? Thanks!

dear friend
go to the "calculated measures" tab of ur analysis services where u create the calculated measures...
there z a default "calculated measure" that comes under which u make and create all new measures..
i think by mistake u wud have deleted that default one..just go and create one more default calculated measure and i think its goona solve ur problem..
do post me back if the problem persist

regards
sid|||

Do you mean the first node of the default,that is, "caculate" in the calculated measures tab?

No, I have NOT deleted that.

I found something. If I delete all dimentions and add one again, the problem will be solved. The problem is still there if I only delete one dimention and add it again. I need to delete All dimentions, but only need to add one again, the problem is gone.

Why?

Thank u.

|||

Other things to check :

Have you specified default member on any dimension and/or attribute?

Is there any attributes that have "IsAggregatable" property set to false?

If you loaded many records and each measure value is 0 or NULL, at the end your result will allways be 0/NULL.

Vidas Matelis

|||

1.What you mean default member?

2.Yes, I have some attributes that have "IsAggregatable" property set to false. That is because my dimentions are father-son dimentions, so I set the fatherKey attributes's "IsAggregatable" property to false.

3.Of cause, my records's measure value is not 0 or Null. In fact, when I drop the dimention and then add them again the problem will go.

Thanks.

|||

1. For each dimension attribute you can specify default member. Then queries that do not specify anything for that attribute will use default member.In dimension editor when you select attribute, you can see property "DefaultMember". Lets your have country dimension/attribute and your fact records are assigned to european countries. But if you selecte default member "USA", by default your queries will be executed for "USA" country.

2. I guess this is your problem. Try to set IsAggregatable property to true and check for results. The way it works, that if you set this to false, then in queries where this attribute is not specified SSAS uses member from DefaultMember property. If there is no defaultMember specified for attribute with IsAggregatable=False, then default member is choosed for you. More info here: http://msdn2.microsoft.com/en-us/library/ms175626.aspx.

You might also experience strange results if more than one attribute in the same dimension has different specified default memeber.

Most parent/child dimensions by nature can be aggregatable, so double check if there is business requirement to set IsAggregatable to false there.

3. I was just double checking.

Vidas Matelis

|||

Vidas，I found sothing.

Yes, my dimentions are all father-son type dimentions, and I set the fatherkey's attribute's IsAggregatable property to False. That's the cause. When I change it to True, I could explore the data now.

At this time, the father-son dimention's default member will be chosed as the top node. In fact that's why I could not see any data in the cube's explorer TAB. Because the records are bound to another node of the father-son dimention, which is not the son the the TOP node.

I checked the data records, and found an interesting thing.

I found that if I set the fatherkey's attribute's IsAggregatable property to False, and keep it's default member to Nothing, the father-son dimention will NOT have the ALL member. You could do this and check it in the dimention's explorer TAB, and you will find that the ALL member is gone. Why?

Thanks.

|||

Ivanchain,

When you set IsAggregatable property to false, it is expected that that attribute will not have ALL member. This is by design. When IsAggregatable = False, you are telling SSAS that there is no point aggregating all members. More info here: http://msdn2.microsoft.com/en-us/library/ms174497.aspx

I am glad you found source of your problem.

Vidas Matelis

|||Thanks dear friends!

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0

|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks
|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent
sql

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Can't seem to build simple cube in SQL 2005

I have a relatively simple cube, with the exception that some of the tables in my data source view are named queries from different databases.

Whenever the cube processes, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported..

When I switch the data source to use the OLEDB for SQL Server instead of the native client, it complains of invalid columns in the query (there are no invalid columns in the query, I can browse the data from the designer and run the query successfully).

Anyone know how to get past this issue?

Hi, Did you find a solution to this, as I'm experiencing the same situation.

Thanks,

Steve

|||Yes, I eventually figured it out. I had to switch every connection to use oledb for it to work, even ones not associated with the query giving the error.|||I hit this same issue as well...does anyone on the SSAS team know more about this? Why doesn't the default provider work? The strange thing is that was JUST working fine and I don't know why I started to receive this error.

Error 1 OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000. 0 0|||Did you find an issue to this problem ? I encounter exactly the same thing.

Thanks|||I have not tried this again since sp2 came out, but I would make sure the service packs are applied. Otherwise, the only workaround is to change ALL the connections to use the OLEDB provider. If any of the connections use the new provider the error will continue to occur.|||Thank you for your reply. All my connections were using OLEDB provider and I still had the problem.

Anyway, by the same time we changed our test server (hosting both the databases and the visual studio solution) and I don't have the problem anymore with this new server. I hope it won't occure again !

Thanks again

Vincent

Cant see my Analysis Services Cube in Excel....

Im having the symptoms described in:
http://support.microsoft.com/kb/287079/en-us
But have tried the workaround to no avail. An important note would be that I
have Excel on Box1 and AS on Box2. When connecting to AS on Box1, this issue
doesnt occur.
Any other ideas?
TIA, ChrisR
Just found my answer @. droptable.com.
The cube must be processed first.
"ChrisR" wrote:

> Im having the symptoms described in:
> http://support.microsoft.com/kb/287079/en-us
> But have tried the workaround to no avail. An important note would be that I
> have Excel on Box1 and AS on Box2. When connecting to AS on Box1, this issue
> doesnt occur.
> Any other ideas?
> TIA, ChrisR
>

Cant see my Analysis Services Cube in Excel....

Im having the symptoms described in:
http://support.microsoft.com/kb/287079/en-us
But have tried the workaround to no avail. An important note would be that I
have Excel on Box1 and AS on Box2. When connecting to AS on Box1, this issue
doesnt occur.
Any other ideas?
TIA, ChrisRJust found my answer @. droptable.com.
The cube must be processed first.
"ChrisR" wrote:

> Im having the symptoms described in:
> http://support.microsoft.com/kb/287079/en-us
> But have tried the workaround to no avail. An important note would be that
I
> have Excel on Box1 and AS on Box2. When connecting to AS on Box1, this iss
ue
> doesnt occur.
> Any other ideas?
> TIA, ChrisR
>

can't see calculation definition

Hi, new in SSAS 2005, few weeks ago I define calculations in my cube, deploy it and built it. When I browse the cube, its OK.

Now I re-open the project file, I cant see this definitions (formula) but I still can browse the cube and see the values.

1. I'm worried if I re-deploy the cube, I'll loose calculation definitions definitily, or even worse :(

2. is there a way to recover this definitions?

thx

Julio

If you lost the MDX definitions in the project somehow but they still exist on the server, you import server state into new project. Just do New -> Project -> BI Projects -> Import AS 9.0 Database|||Thank you very much :)

Can't see any data when I browse the cube :(

Hi,
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ' I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.micr
osoft.com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ' I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.

Can't see any data when I browse the cube :(

Hi,
I have made sure that on the server I am a member of the OLAP
Administrator group and everything seems to go well all the way up to
Design storage and Cube processing
but
After that I can only browse the dimensions and can see the data but I
do not see any data when I browse a Cube ? I'm really confused and
can someone please help me out. Really urgent and desparate
Thanks.
Learner <wantnospam@.email.com> wrote in message news:<MPG.1b8184915dc05c8a989749@.msnews.microsoft. com>...
> Hi,
> I have made sure that on the server I am a member of the OLAP
> Administrator group and everything seems to go well all the way up to
> Design storage and Cube processing
> but
> After that I can only browse the dimensions and can see the data but I
> do not see any data when I browse a Cube ? I'm really confused and
> can someone please help me out. Really urgent and desparate
Hi,
are u using analysis servuces. if yes then right click on the cube
select manage role and give it permission to be access. That may be
the problem.
Regards
Harsha Mogatala,M.Sc.

Can't Run any DM Until Delete Lost Cube? (even when I start a new Project from scratch!!)

Can't Run any DM Until Delete Lost Cube?

Even if I start a new Project from scratch I get the same error,

Even if in the new Project I press "start debug" before I create anything.

There is no connection, no data source view, no ...

Can you provide more details?

What error are you seeing? Are you seeing this error in Business Intelligence Development Studio?

Can't Run any DM Until Delete Lost Cube?

I (unsuccessfully) made a cube named, MSR TRANCHES. I can't find any trace of it anymore. However, I can't make a new Mining Structure because VS complains of:

Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the MSR TRANCHES ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml'. 0 0

I can't find any cube anywhere, nor do I find this missing file. How does Visual Studio know to look and how do I clear this up.

Thank you very much,

I obtain the same error when I try to develop a mining structure. Anybody know the solution?

Thanks in advance.

|||The error you're seeing indicates that the database is corrupt (internal files associated with certain system objects are missing). If you don't have any other database/objects you need to save on the server, the workaround would be to shut down the AS2005 service (SQL Server Analysis Service (<instancename>)), delete the "\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Data" folder and restart the service.

Can't Process cube created with ASCMD - XMLA script -

Hi,

I have an XMLA-script that I use for creating my cube. Creating the cube with the tool - ascmd - is not an issue but when I try to process the cube, I get the following message:
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 28000.

Strange because when I open the management studio -> look at my data source, all the correct information is there (server, user name, etc.), except for the password field in impersonation account editor, which is blanco.

The only way to process my AS DB is to open the data source editor and retype my password in the impersonation account editor. Once I've done that, I can process.

But as I want to automate the cube processing, I have a problem...

Anyone?

greets,
-Tom

Here's the solution:

<ImpersonationInfo>
<ImpersonationMode>ImpersonateAccount</ImpersonationMode>
<Account>mUserName</Account>
<Password>mPassword</Password>
</ImpersonationInfo>

I just had to add the password tag in my xmla-script...

This seems to be a bug, because while I was creating the cube in VS, I've set the option 'Remove passwords' in project properties to false.

Now the only thing that really bothers me is the fact that I have to put passwords in a script file (available to anyone). Anyone has an idea?

-Tom