OWC, Pivot & "OR" queries

this is probably a very easy question but I can't seem to find an answer...

Is there any visual way of building a query in OWC that includes a couple of conditions included as 'OR'?

basically every dimension I drop becomes a condition but they all get added as 'AND' & I can't seem to have a way to do 'OR' - even cube browser in BI studio doesn't have this option...

You can do OR between members of the same hierarchy (hopefully on the same level). Just select multiple members from the same hierarchy.|||

if it was the same dimension it'd have been easy, but it's a bit complicated since it's a role playing dimension & so even though it's the same hierarchy & same level it becomes 2 different dimensions.

something like this: DateOpened.Year = 2000 or LastRenewalDate.Year = 2000?

|||You cannot do it in OWC. You will have to write your own MDX queries to do it.

OWC scans all partitions (SSAS 2005)

Hello,

I have a cube with three partitions. Each partition holds data for the years 2005,2006 and 2007 respectively. In our web application we are creating OWC Pivot Table and putting "date dimension" in the filter area automatically. Altough only "2007-01-01" is included in filter, when we trace the query from profiler we saw that all partitions are read. Is there anyone encountered the same thing?

By the way, storage modes for all partitions are MOLAP.

Nilgun Celikok

Hi Nilgun,

First of all, have you set the Slice property on your partitions? Although in general AS is able to detect what data is in each partition, read the following article for details on when it will and won't work:

http://blogs.msdn.com/sqlcat/archive/2007/03/05/ssas-partition-slicing.aspx

In your case it sounds like it will be quite straightforward to set the slice, and this will also detect whether your partitions hold the data you think they hold (which could be another reason why you're seeing AS scan all partitions).

If you have set the slice, however, you could be running into an issue I've seen before and which I think is fixed in the latest cumulative hotfix build for SP2:

http://support.microsoft.com/kb/936305

Look for the brief description under issue 50000890.

HTH,

Chris

OWC in Windows 98 connect to Analysis Services 2005

Is there a posibility to make OWC installed in Windows 98 connect to Analysis Services 2005?

The thing is we cannot install the OLE DB Provider 9.0 for Analysis Services 2005, because it needs Windows Installer 3.1, and we really need to connect OWC to 2005, because we could do it with Analysis Services 2000.

How can we do?

Thanks in advance.

If you want to use OWC, you must have the OLEDB provider 9.0 for Analysis Services. OWC executes on the client and uses OLEDB to talk to the SSAS server.

Unfortunately the only options I can think of if you cannot get the OLEDB provider installed is to either upgrade the client or to look at using something other than OWC. Some of the commercial "thin client" solutions would probably work. Mosha has a list on his site at www.mosha.com/msolap .

OWC and SSAS 2005

So I am about to impliment my intranet site with my pivot table reports that conect to SSAS2005 cubes, I am just curious if anyone knows the minimum requirements that need to be installed on the client for them to be able to view the report. I know they need msxml6.msi and SQLServer2005_ASOLEDB9.msi installed but what version of office web components are required? Does anyone know.

I am trying to play it as safe as possible but I don't think installing Office XP web components is feasable, will 2003 web components work?

Thanks in advance for the help.

OWC 2003 will work against AS 2005. As you mentioned you need to get AS OLEDB 9 installed.

In fact is you mention, SQL Management Studio and BI Dev Studio using OWC for browsing cubes.

Though there are quite a few better AS clients out there in the market that work way better with AS2005. Excel 2007 pivot tables for example.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yeah, I was just looking if someone knew the oldest version of office web components coupled with the install of the OLEDB provider and the XML services that would work for browsing cubes.

OWC and AS 2005 Cube Drillthrough action

Hi There,

I setup drillthrough action on AdventureWorks sample cube, and am able
to view drillthrough through cube browser. However when I use OWC
(office web component) 11 (office 2003) to connect to the cube, I can
still open up drillthrough in the IE with all the dimension name, but
without any data.

Does OWC 11 support AS 2005 Drillthrough, we use OWC 11 on AS 2000 cube
drillthrough and work fine?

Does anyone get drillthrough working on AS 2005 cube in OWC 11?

Thanks
Dong

Hi Dong,

I haven't use plane OWC for a while and can't try this scenario right now. But if you still have a problem, please run SQL Profiler when issuing a drillthrough command and action (Discover request MDSCHEMA_ACTIONS) from OWC and Browser and see for any noticable differentces between the two. You can also post those commands in this post, may be we can find the problem together.

OWC - Distinct Count Error

hi,

i have a cube where i do a "distinct count" of my customers and it works fine if i select one member off a dimension or all of them. but if i try to choose two or more members it doesn't work anymore.

does anyone have a solution for this problem ?

thanks,

levogiro.

Are you using AS 2005 SP2 - in which case, could you describe the issue in more detail?

http://sqljunkies.com/WebLog/mosha/archive/2006/11/07/visual_totals_dc.aspx

>>

Visual Totals and Distinct Count

One of the most talked about improvements in Analysis Services 2005 was support for Distinct Count measure over arbitrary set of members.

...

Wrong results are always a bad thing, therefore in SP2 the implementation of Visual Totals (both function and the mode) underwent serious change. Internally, this implementation got unified with implementation of visual totals for subselects - so now they all behave similarly.

>>

|||

Deepak Puri,

I'm sorry, I forgot to say that I'm using SQL Server 2000. I did a test in SQL Server 2005 and it works fine.

Levogiro.

|||I believe there was a hotfix for this issue (in AS 2000) recently. Please follow up with CSS...|||I have the same problem. Does anyone know if there actually is there a hotfix for AS2000 for this?

OWC - Distinct Count Error

hi,

i have a cube where i do a "distinct count" of my customers and it works fine if i select one member off a dimension or all of them. but if i try to choose two or more members it doesn't work anymore.

does anyone have a solution for this problem ?

thanks,

levogiro.

Are you using AS 2005 SP2 - in which case, could you describe the issue in more detail?

http://sqljunkies.com/WebLog/mosha/archive/2006/11/07/visual_totals_dc.aspx

>>

Visual Totals and Distinct Count

One of the most talked about improvements in Analysis Services 2005 was support for Distinct Count measure over arbitrary set of members.

...

Wrong results are always a bad thing, therefore in SP2 the implementation of Visual Totals (both function and the mode) underwent serious change. Internally, this implementation got unified with implementation of visual totals for subselects - so now they all behave similarly.

>>

|||

Deepak Puri,

I'm sorry, I forgot to say that I'm using SQL Server 2000. I did a test in SQL Server 2005 and it works fine.

Levogiro.

|||I believe there was a hotfix for this issue (in AS 2000) recently. Please follow up with CSS...|||I have the same problem. Does anyone know if there actually is there a hotfix for AS2000 for this?