 File system error when deploying an AS2005 project [0 replies]
microsoft.public.sqlserver.olap, Sunday, January 29, 2006
Hi,
When trying to deploy a new Analysis service project with Business
Intelligence studio, I've the following error (translated from French
since I use a french version of the tool) :
----...
Improving the Sql environment at our Place ? [0 replies]
microsoft.public.sqlserver.olap, Saturday, January 28, 2006
I need to improve the sql setup at my current location (long term contract)
Currently there are
100+ msde installations (1 gb average running a retail back end processes)
Backup to dis...
Using 2 fact tables in AS2005 [1 reply]
microsoft.public.sqlserver.olap, Saturday, January 28, 2006
Hi,
I am trying to come to grips with AS2005's ability to have two fact tables
in a cube and to create calculated measures that work successfully.
For background, the two fact tables ...
FROM date TO date [2 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
How to create calculated member when all date members like
'T00:00:00' to slice by 'FROM DATE TO DATE' period.
That is the 'PROTOTYPE' OF MDX that I need to have:
with memb...
Web Client for Cubes [1 reply]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
In AS2000 we used Pivot table (OWC) to get Cube data on web. I think that was
not easy to do, I mean lot of coding....
Is there any thing new we have with AS2005 for web client. I understa...
Parent/Child relationship on rows [4 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
I can browse cubes to see the following output:
Unit Sales
1997 Q
Q
Q
Q
Is it possible to ...
olap provider bug? [0 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
Hello,
The MDX below executes fine when connecting using the following connection
string:
"Provider=MSOLAP.2;Client Cache Size=25;Data Source=MYSERVER;Auto Synch
Period=10000;Initial Cata...
XML for analysis services problem (details) [2 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
I have a analysis services database running in my computer and I have
installed the xmla v 1.1
I created the virtual directory in IIS 6.0 with the file msxisapi.dll
but I can't connect my ap...
WhereScape for SSAS [0 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
Hi,
We have now the new version 5.0 available of WhereScape with support of
MS SQL Server 2005 and SSAS OLAP Cubes.
A free trial can be downloaded from: www.gmsbv.nl
Best regards,
Ma...
Time dimension [0 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
I am working on a cube that has a time dimension. My fact table has one entry
for each day and I have generated a time dimension table containing dates for
many years ahead. This time dimen...
Can't connect AS2005 - Excel 2003 [0 replies]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
Since we couldn't get Excel 2003 to connect to AS 2005 through HTTP (well
documented in this newsgroup), we decided to fall back on Windows
Authentication for some users, and delay roll out...
AS 2005 - XMLA Language issues [1 reply]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
I have a problem with Analysis Server 2005, more the XMLA side on the
msmdpump.dll.
My analysis cube contains source columns for dimensions are set as
nvarchar, allowing me to store ...
Parent-Child Hierarchies and Visual Totals [1 reply]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
In SSAS 2005 is it possible to use visual totals when defining security on a
parent-child hierarchy?
e.g.If you put
[Employee].[Employees].&[277]
in the allowed member set it works
Th...
building a web site [0 replies]
microsoft.public.sqlserver.olap, fri,
I just got back working on my website. Its taken a long time to finish but I am getting there.
I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a ...
Client connect SQL Server 2005 AS [1 reply]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
Hello!
I am trying to deploy an OLAP client written in .NET.
My test machine is freshly installed Win XP SP2. The only things installed
at this stage are:
- PTSclient.exe (SQL Server S...
Repository connection error [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hi all,
I have a team of AS developers. All are able to access one development
machine, all but one can access the production machine. The individual who
cannot is getting a repository...
Migrated Foodmart. Error at processing. [1 reply]
microsoft.public.sqlserver.olap, Friday, January 27, 2006
Hi,
I get following error message at processing of the migrated FoodMart 2000.
Errors in the back-end database access module. OLE DB reported the ''
status, which is unknown, for column...
How do I configure Analysis Services for Excel 2003 users? [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hi,
I have been preparing a set of cubes in Analysis Services 2005 to be viewed
using an Excel 2003 front end and am struggling with deployment issues.
Excel reports have been designed ...
Calculated Measure/Total for the year [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hi,
I am trying to create a calculated member that will give me the total yearly
budget amount even if I am looking at a specific month. Here is what my
PivotTable report looks like:
P...
JoinClause Property [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hi,
1) Can we set the JoinClause property of the partition through Analysis
services GUI?
2) Can we give a join hint (Hash table, nested loops) through the
joinclause property so that a...
Calaculated measure problem [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
What is happening is that in the calculated measure formula when something is
being divided by 0.XX its producing those wrong figures where decimal is at a
wrong place. But if we divide the...
Can't build dimensions when RDBMS is Sybase (AS 2005) [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hello,
We are trying too migrate to AS2005 and our datasources include Sybase ASA
and Sybase ASE.
The problem is that we cant process the dimensions, due to syntax errors.
We know that we...
Many to Many Relationship [1 reply]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hi,
Can anybody explain me what the meaning of the Relationship “many to
many” is? Where I can find an example for that or in which case I must
use this kind of Relationship?
Thanks
...
Excel OLE DB Connection [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hi,
I have a SQL Server 2005 Database with AS 2005 cubes and as Front End I
use Excel 2003 via OLE DB 9. Anything works fine.
Now I want to install all the components (database, cubes and...
Percent of a child vs Parent (Cummulative) [1 reply]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Hello,
I have TIME, ARTICLES, STORES, COLOR as Dimensions.
When I´m at the leaf level of ARTICLES, I do MDX that calcs the cummulative
participation of this value, against the total of his...
Hotfix for SP4 [0 replies]
microsoft.public.sqlserver.olap, Thursday, January 26, 2006
Do I have to pay Microsoft Support in order to obtain a hotfix for AS 2000 SP4?
|
