I have a Dataset which has 2 hierarchies and a Measure. Brand, Customer and Volume. (Brand and Customer are not in the same hierarchy) Now say my...

Denver

04-26-2006 12:19 PM
Deepak Puri

If we had 3 Dimensions and 1 measure and there are numerous Calculations defined on which the top consolidated value is dependent,...

Avril

04-26-2006 09:28 AM
Avril

no aggregations (cube dir empty and query performance poor) created when using holap. switching to molap resolves. a bug or am i missing a...

Steve S

04-26-2006 07:48 AM
BK

Hi, Im trying to insert into Excel result from Olap cube by exec procedure with MDX function in SQL: ----- declare @qry nvarchar(4000) set @qry =...

AT

04-26-2006 05:26 AM
AT

I've been migrating an SSAS 2000 database to SSAS 2005, and try to explain an issue below: 1. In AS2000 I have a number of dimensions whose levels...

Steve G

04-26-2006 04:53 AM
Steve G

Hi, is there a way to hide measure from calcuation code. Something like assigning default member: ALTER CUBE CURRENTCUBE UPDATE DIMENSION...

Vimas

04-26-2006 12:37 AM
AT

How do I sort month hierarchy in the time dimension? My months are displayed as March, Jan, Feb. instead of Jan, Feb, March. The tutorials in ssas2k5...

sqlster

04-25-2006 10:45 PM
AT

I need the date of my Last Day with data. This works fine in a SELECT statement: SELECT {.} ON 0, Tail(NonEmpty(Time.Date.MEMBERS,.),1).Item(0) ON 1...

PeterG

04-25-2006 04:27 PM
bhorwatt

Hello- I need to increase my Analysis Services drill to details row limit of 1000. How do we do this? I'm on SQL Server 2000. Thanks! Peter

rower99

04-25-2006 04:12 PM
rower99

Hi. I'm migrating an AS2000 database to AS2005. It works ok in 2005 (processing, browsing, etc.). If I modify the database in BIDS in "online"...

Andres

04-25-2006 02:31 PM
Andres

Hi: I am creating a Cube using SQL Analysis services. I have created a date dimension with 10 year's worth of dates. In the cube editor I...

Kayda

04-25-2006 02:15 PM
Kayda

Hi I am using MDX in RS and am currently constructing a chart where by the series part is inputted by a user. This is fine for construction of...

Denver

04-25-2006 01:38 PM
Denver

Wizard changed a measure name to Length] -------------------- Chris Harrington

ChrisHarrington

04-25-2006 01:29 PM
Adrian Dumitrascu [MS]

Just checked SSAS after installing SP1 and guess what ? Ragged Hierarchies is still not working. I tried the classical customer dimension and made...

Bobby Henningsen

04-25-2006 01:27 PM
Edward Melomed [MSFT]

I am trying to set up an SSAS role whose members are not able to see certain dimensions altogether. This link explains that I can do this...

Dan

04-25-2006 12:21 PM
Akshai Mirchandani [MS]

Adding OLAP ng -- -Jamie MacLennan SQL Server Data Mining This posting is provided "AS IS" with no warranties, and confers no rights. PLEASE POST...

Jamie MacLennan \(MS\)

04-25-2006 12:18 PM
Jamie MacLennan \(MS\)

adding OLAP group -- -Jamie MacLennan SQL Server Data Mining This posting is provided "AS IS" with no warranties, and confers no rights. PLEASE...

Jamie MacLennan \(MS\)

04-25-2006 12:15 PM
Jamie MacLennan \(MS\)

I have a Dataset which has 2 hierarchies and a Measure. Brand, Country and Volume. Now say my dataset looks like this Country - Brand - Volume UK -...

Denver

04-25-2006 06:52 AM
Denver

Hi I have been playing with MDX for a couple of weeks now to produce reports in SQL Reporting services. I have hit a bit of a wall. I want to...

AT

04-25-2006 05:14 AM
Darren Gosbell

Hi All, I have replaced the query in mdxquery.xml of sample application with the following one. When I run this query , it displays me "Subscript...

Uma

04-25-2006 03:19 AM
Uma

I am trying to set up a cell calculation using DSO and can not figure out why it fails. The code is in VB6 (also tried in c#) but to no avail. Any...

cubes

04-25-2006 12:37 AM
Deepak Puri

can anyone tell me Is there any option to set the default view for cellsetgrid control?.

Uma

04-24-2006 11:11 PM
Uma

So far, I have been using business intelligence development studio's wizards to create cubes and dimensions. How can I create cubes using script...

sqlster

04-24-2006 11:07 PM
Jeje

I have a fact table called "factCensus" in which I maintain one record for each day an employee is "active" in the company (e.g. if an employee...

Ashok G

04-24-2006 04:26 PM
Ashok G

Hi there, I am experiencing a problem when attempting to drillthrough on a Virtual Cube, after implementing Dynamic Security with a Shared Dimension...

NigelFoulkes

04-24-2006 11:59 AM
NigelFoulkes

I have a small cube (170,000 rows in the fact table, 18 dimensions) and I need to be able to nest several dimensions on the rows, which...

rachel

04-24-2006 10:52 AM
Deepak Puri

Hi, Do anyone of you know how to see the MDX generated by the Pivot Table? Regards Anu

Anu

04-24-2006 10:47 AM
AT

hola desde hace un timpo cuando trato de hacer un cubo olap, me aparece la ventana de instalacion de visual fox 7 y de otro producto que se...

Fernando Ugarte

04-24-2006 09:17 AM
Fernando Ugarte

Hi, I have a measure in a facttable where I would like to have a dimension group based on. like <25 , 25-50, 50-75 and 75-100. There are a lot os...

Marco

04-24-2006 09:05 AM
cubes

Hi, I have encountered the same problem, as mentioned...

preeti Ekadunni Unnay

04-24-2006 05:24 AM
preeti Ekadunni Unnay

Hi I was hoping an MVP could clarify the following: Does the query log and the usage based optimization work on 64 bit SSAS 2000? For some reason,...

Avi

04-23-2006 09:30 PM
Avi

Where can you find the equivalent limitations for SQL Server 2005? Item Specification Dimensions in a database 65,535 maximum, regardless of the...

Avril

04-23-2006 12:15 AM
Avril

I have dimensional security set up for some of my users - when they access the data via a pivot table for the dimension I have secured the pivot...

AnnetteKramer [Vizion Solutions]

04-23-2006 12:00 AM
Deepak Puri

Hi Akshai / Deepak / Mosha , I am currently setting up Dynamic security using the Filter in the Allowed Members for User. I want to restrict the...

M Mansoor

04-22-2006 10:03 PM
Deepak Puri

Here is my situation, I have following measure QTY_YES, QTY_NO, QTY_UNK and Dimension : Chargable (All),Y , N or U

Kalyan

04-21-2006 08:28 PM
Darren Gosbell

I have following measure QTY_YES, QTY_NO, QTY_UNK and Dimension : Chargable (All),Y , N or U IF Chargable

Kalyan

04-21-2006 08:28 PM
Darren Gosbell

Hi, I am stucked in a situation in MDX where I need to recognize if Current day is the last Day of the Month. For example, I need to know if...

Dani

04-21-2006 08:16 PM
Darren Gosbell

Hi, Is there any way we assign Alias Name in MDX Qry ..for example select { ...members on rows from Warehouse Now I would like to assign alias name...

Kris

04-21-2006 07:45 PM
Darren Gosbell

problem!!!! below is one of the question from the Survey: which color you like? (select all that apply) Red Green Blue .... and so on 20 more

Sam

04-21-2006 02:46 PM
Sam

I have a Cube with 30 Dimension and it can grow to 75 or more. Last night i tired to process the cube and in storage wizard it had 656 aggregation...

msam77@gmail.com

04-21-2006 01:41 PM
Edward Melomed [MSFT]

Hello, how to allow normal user (not Administrator) deployment of SSAS Cube? It says always that normal user cannot create new objects. Andrey.

Andrey Belkin

04-21-2006 01:33 PM
Edward Melomed [MSFT]

I am using AS2000 with SP4. I have a cube which has been fully processed. I got the Max(ID) = 27199456 from the fact table and then executed a...

lmcphee

04-21-2006 11:13 AM
lmcphee

Hello, I'm trying to invoke a report services report from by AS 2005 cube. However with following settings I get no results Name: Report action...

JosephT

04-21-2006 10:21 AM
JosephT

Hi Folks, i must display a text information as a measure - i do this via a Member Property iif( .currentmember.level.name =...

hoffmadi

04-21-2006 09:46 AM
hoffmadi

I'm trying to consolidate data from multiple local cubes into a single local cube. These local cubes will have the same structure, just different...

Chris

04-21-2006 08:48 AM
BK

This should be an easy one... Ok, I create a Report Model Project from the Business Intelligence Projects Templates. I want to create a data source...

Paul W

04-21-2006 08:18 AM
Paul W

Message distribué sur microsoft.public.sqlserver.olap,microsoft.public.office.dataanalyzer ___________________________________ Hi does anyone use MS...

Umin

04-21-2006 04:36 AM
Paolo Andrea Zaccheddu

I can't connect to AS2000 on my local machine using the sample.net application from the xmla 1.1 sdk. I installed AS2000 with SP4. I installed XMLA...

Uma

04-21-2006 04:04 AM
Uma

Hello, I am using CellsetGrid component for OLAP on asp.net when I load the cellsetgrid the first , it work well, but when I...

jim

04-21-2006 02:23 AM
jim

I am still learning OLAP in Analysis Services 2000 SP4. Is it possible to reference the calculated member from an underlying cube in a virtual...

dustbort

04-20-2006 04:54 PM
dustbort