OLAP 2007

[informer30]

Hi All,

I am new to MS Excel and olap connection. I have connected to the olap cube and placed two fields in the report filter.

field 1
field 2

Now I want to code to bring back data where it meets the following condition

field 1 or field 2
or (field 1 and field 2)

Where do I code this?

I am using MS Excel 2007.

Many Thanks

 

[kjv1611]

Have you looked at using MS Query?

 

[informer30]

What do you mean? and how?

I am new to this all..

Thanks

 

[kjv1611]

Here's Microsoft's reference dealing with the OLAP cube, it says:

http://office.microsoft.com/en-us/excel-help/CH010064853.aspx

Here's a reference showing how to build an OLAP Cube:

http://wang.se/en/CreateOLAPCube.html

You'll notice that last reference specifically is using MS Query. So if you're talking about an OLAP Cube, and don't know what MS Query is, you probably need to do some more research.

The link I put in my first reply tells you the basics of how to use MS Query to connect to an external data source. So I'd start looking there.

If you're needing to automate things, to handle something that can't be handled via MS Query, then you'll probably need to look at using VBA. You can access the VB Editor Windows by pressing <Alt> + <F11>. If it doesn't come up, make sure this option is enabled in Excel '07:
-->Office Button -> Excel Options -> Popular -> Show Developer tab in the Ribbon