×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating local cube slices.

Creating local cube slices.

Creating local cube slices.

(OP)
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.

RE: Creating local cube slices.

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!)

RE: Creating local cube slices.

(OP)
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.

RE: Creating local cube slices.

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

With some dimensions I receive that message...

Could anyone solve this problem ???

RE: Creating local cube slices.

(OP)
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.

RE: Creating local cube slices.

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 ???

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close