Creating local cube slices. 1

[gkotrick]

I'm relatively new to OLAP data sources. Has anyone attempted to create local cube slices from an OLAP source through Visual Basic using SQL queries instead of MDX queries? I have the Visual Basic structure set up and am able to create a full local cube based on the OLAP server using the typical Select/From SQL structure. I have also been able to create CUBE slices using Select/From/Where syntax. The problem is that depending on the dimensions I choose in the the Where clause I receive the following error...

"Error while processing a partition: 'Processing error [No members where found in the dimension] Measures'.

Is there a way to ignore the offending dimension and continue processing?

Thanks.

 

[SQLUser]

The error "No members found..." usually comes when you have an empty dimension table (no rows)

1. Either you enter some rows in the dimension (and remember to PROCESS it!). If you do have rows, process the dimension individually from OLAP mmc console.
OR
2. Edit the cube and remove the dimension (don't remove the table from the db). A blank dimension is of no use anyway.

Then process the cube.

Even though having "OLAP service pack 2" doesn't really affect your case, I suggest installing it (if you haven't). It has fixes for a lot of problems.

Let me know how it worked out (and if I'm right!)

 

[gkotrick]

Thanks for the info, but would it be an empty row in a dimension table or an empty row in the fact table? I've checked the source data and all dimension tables are populated correctly, but, when I use the MDX sample application installed with OLAP and I query for the same data, there are blank measures.

Basically what I am trying to do is to create an offline cube slice based on an OLAP data source (not the relational DB source). Excel 2000 is capable of doing this but what I need is a programmatic (Visual Basic) solution and though the Excel 2000 macro recorder simplifies a programmatic solution for a relational DB source, the macro recorder does not record the process for connecting to an OLAP datasource. I've read numerous OLAP articles and books all stating that SQL statements can be used to query an OLAP datasource. All of the examples were very simplistic and very few used the WHERE clause. In my testing of the WHERE clause, I was met with mixed results. Sometimes it worked, other times I received the error message that prompted the initial message post in this forum.

BTW: I do have SP 2 installed.

Thanks again.

 

[Abellon]

I'm having the same problem when creating local cubes...

With some dimensions I receive that message...

Could anyone solve this problem ???

 

[gkotrick]

I upgraded to SQL 2000 and tried to gain a better understanding of the CREATECUBE and INSERT INTO statements which are used in conjunction with the SELECT...FROM...WHERE clause. I'm not sure which it was but I am no longer experiencing the problem.

 

[Abellon]

But you had to change any code to work with SQL2000 ???

Specially in the where clauses ???

could you send me an example of a complex code you have created that works OK in SQL2000 ???