| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | There is any way to call the SSAS COM from a VB application?
I want a way to "masquerade" the Microsoft Visual Studio/File/Open/
Analysis Services...
Juliano
|
05-17-2010 07:00 PM
epdAaronK  | 1 | 276 |
| | | I have a 1.8TB drive with 310GB free. I'm trying to overwrite an existing
backup that has a size of 268GB compressed, with the data size of...
Jesse O
|
05-17-2010 10:34 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA] | 2 | 218 |
| | | I'm having trouble migrating a local cube from SSAS 2000 to SSAS
2008. Foodmart. Brand new install.
SSAS 2000 SP4
SSAS 2008 SP0
I'll try...
epdAaronK
|
05-17-2010 10:31 AM
a a r o n . k e m p f @gmail.com [MCITP: DBA] | 1 | 209 |
| | | Hi,
I’m new to SSAS and I’m hitting a Security puzzle that I’m struggling to
solve.
Our simple cube contains IT Billing information for our...
Rich
|
05-17-2010 02:09 AM
Rich | 0 | 189 |
| | | Hi,
I’m new to SSAS and I’m hitting a Security puzzle that I’m struggling to
solve.
Our simple cube contains IT Billing information for our...
Rich
|
05-16-2010 12:46 PM
Rich | 0 | 194 |
| | | Hi
I have a Cube that consists of a Net Sales Value Measure , linked to a
Company Dimension and a Salesperson Dimension. The same Salesperson
could...
Que
|
05-14-2010 04:17 AM
Que | 0 | 206 |
| | | Hi all
Just trying to get to grips with cubes and have setup a test server with
SQLSVR2K and Analysis Services. Like a good boy I've installed SP4...
Nick Horrigan
|
05-13-2010 11:05 AM
Nick Horrigan | 0 | 193 |
| | | I am trying to deploy my cube on a new installation of SQL Server and
Analysis Services 2008. When I try that it gives me the following error:...
AmirCharania
|
05-12-2010 01:59 PM
AmirCharania | 1 | 246 |
| | | Sorry, in the subject I meant SSAS 2008.
AmirCharania wrote:
AmirCharania
|
05-12-2010 01:57 PM
AmirCharania | 0 | 201 |
| | | I wonder if anyone has run into this before.
I'm trying to produce a report in which all rows are sorted by a specific
column. For example the...
Stan Kondrat
|
05-10-2010 02:51 AM
amish | 1 | 257 |
| | | Hello.
I need a brief description of SSIS and worlds, example, etc.
Need to know how this look like.
Also, if there is a tutorial or VM-WARE server,...
Mr. X.
|
05-01-2010 04:11 PM
Mr. X. | 0 | 262 |
| | | Not sure if this is the right place to post but ProClarity is a tool for
viewing OLAP data.........
Since installing the ProClarity service pack...
Dazza
|
04-30-2010 01:01 PM
Dazza | 0 | 238 |
| | | I'm doing the SSAS tutorial and had a question about the "Define a Cube" page
http://msdn.microsoft.com/en-us/library/ms170228(SQL.90).aspx#
In...
mcp111
|
04-27-2010 04:05 PM
Mark Fitzgerald | 1 | 302 |
| | | Hi All!
Is there any way within SSAS to create a dynamic dimension which would group
values of a measure or measures into value groups?
For...
Pasha
|
04-23-2010 04:42 PM
Pasha | 0 | 274 |
| | | I have a dimension with two attribute, like attA and attB. How can I display
one attribue with the order of another attribue. For example, when I...
flying
|
04-20-2010 08:53 PM
Todd C | 1 | 330 |
| | | In defining a calculation, I see that the function Root can be used like this:
Root( ), .
and it would return the grand total (or other aggregate)...
Todd C
|
04-16-2010 08:31 AM
Todd C | 0 | 252 |
| | | I have a calculated member issue that I'm sure is simple but cannot get to
work.
This works fine ....
SELECT
NON EMPTY {., .} ON
COLUMNS,
NON...
Bink
|
04-09-2010 09:07 AM
Bink | 0 | 290 |
| | | Hello,
I need to create an MDX query where I need to display The Measure with respect
to Top 10 Dimesions.
For Eg: I have Segment,Family and Class...
tismylife
|
04-07-2010 12:46 AM
Sakthitnj via SQLMonster.com | 2 | 301 |
| | | Hello,
I have what is probably a pretty simple question.
I'm creating a performance analysis process for a client and want to
automated most if not...
mghale
|
04-05-2010 03:04 PM
mghale | 0 | 286 |
| | | Hi,
i have the following query on Adventure works 2008:
SELECT (..&,.)
ON 0 ,
NON EMPTY Filter (...MEMBERS ,
(..CurrentMember,.)>0)
ON 1
FROM
MIB
|
04-01-2010 03:54 PM
MIB | 0 | 309 |
| | | Hi All,
I have a query that is reading through a large amount of data and I can't
get it to finish. In Profiler, I see activity at first (reads...
Pasha
|
04-01-2010 02:42 PM
Mike Lum | 1 | 317 |
| | | I currently have a calculated member in an OLAP cube to calculate Year
over Year differences (code below).
((.,.CurrentMember)...
Carrie Wilmoth
|
04-01-2010 02:21 PM
Mike Lum | 2 | 304 |
| | | Hi All,
I need some expert advice. Project Sever 2003 Latest SP, SQL 2005 Latest Sp.
When we build the cubes the roles with the permissions in...
Andre Venter
|
03-29-2010 02:27 AM
Andre Venter | 0 | 301 |
| | | Hi,
PTS were integrated into Analysis Services with version 9.0/2005, but for
local cube file access you still need to install them with the...
Ralf Steinstraesser
|
03-25-2010 06:43 AM
Ralf Steinstraesser | 0 | 299 |
| | | I've been receiving the below error more often on my server, even in the
morning when it's realtively quiet.
Any ideas?
Transaction errors:
While...
Jesse O.
|
03-25-2010 06:11 AM
Aditya | 4 | 281 |
| | | I've created a few account cubes that roll up using unary operators
without issue. For example, when you drill down, the child sums up to
the...
Carmaboy
|
03-24-2010 08:05 AM
Mark Fitzgerald | 1 | 273 |
| | | Hi,
I am new to MSAS; I have created a cube which has 1 fact table and 3 dim
tables.
Here is the sample data.
DimA
C1 C2 C3(YrQtr) CGrp
m n ...
Suresh via SQLMonster.com
|
03-23-2010 09:28 AM
Suresh via SQLMonster.com | 0 | 289 |
| | | Hi,
I am trying to use Pivottable (OWC11) as web part in my sharepoint
service (team website).
Does any body have success with that ?
Here is the...
Mallikarjun Tuppad
|
03-23-2010 03:49 AM
Dennischk | 3 | 371 |
| | | To minimise the impact for users we always process our cubes on server A and
then backup/restore them to server B.
Users only access server B.
Now I...
Antoon
|
03-22-2010 03:53 AM
amish | 2 | 390 |
| | | I've been processing a dimension, and about half the time it will fail with
the error: "XmlaError: Server: The operation has been...
Jesse O
|
03-19-2010 12:10 PM
Jesse O | 0 | 302 |
| | | We upgraded some fields in our database, updated the DSV in the build saved
and ran the update and everything went off ok, until we ran the process...
krkolk
|
03-16-2010 03:25 AM
Antoon | 1 | 299 |
| | | Hi,
I have many calculated members defined as 'currency' in format string. When
I pull this calculated members in Excel 2007 they are not displaying...
David
|
03-15-2010 12:27 PM
David | 1 | 284 |
| | | I have been having some strange problems with our SSAS server and I suspect
something is corrupt there since it crashes without apparent reason, and...
Evergreen
|
03-11-2010 03:41 PM
Evergreen | 1 | 382 |
| | | When connecting to the SSAS instance through Management Studio, I only see
one of 12 databases.
However, when connecting to the server through a...
Jesse O
|
03-08-2010 12:40 PM
Jesse O | 0 | 267 |
| | | Hi All,
I am using a C# application and Microsoft.AnalysisServices to generate cubes
based on information in Oracle and SQL server. Overall we can...
Brian Hman
|
03-03-2010 12:36 PM
yssr83 | 1 | 567 |
| | | Hi
Is there a Java driver to connect to SQL Server 2008 Analysis Services? The
JDBC seems to only connect to SQL Server relational databases.
So in...
thebison
|
02-28-2010 02:19 PM
yssr83 | 3 | 779 |
| | | Hi,
I want to create a stored procedure as simple as like in Sql Server
Database Engine (OLTP).
Actually I want to create a stored procedure that get...
Rahul
|
02-27-2010 10:20 PM
sriram | 2 | 664 |
| | | Hi, if there is a better area to post this please let me know, thought I
would start here!
I followed this guide and some MS papers to set up the...
Barrettusa
|
02-26-2010 04:32 PM
a a r o n . k e m p f @gmail.com [MCITP: DBA] | 1 | 580 |
| | | Dear all,
We have a big data warehouse of which the ETL is done using T-SQL. I
very much like to do the processing of dimensions and cubes also...
Paul van Oordt
|
02-25-2010 03:55 PM
Jeffrey Roughgarden | 5 | 794 |
| | | Hello all. I am using SQL 2008 Standard and VS 2008 to develop SSAS cubes.
I create Data Sources that point to my test databases. When I deploy...
Todd C
|
02-22-2010 08:37 PM
Todd C | 1 | 663 |
| | | 許多性能問題和安全性您的計算機*成惡意病毒，最好的辦法對付，這是得到承認和防病毒在計算機上安裝更新
...
antivirus gratis
|
02-22-2010 01:27 PM
antivirus gratis | 0 | 343 |
| | | Hello Tim
Why not create the data in SQL and then keep OLAP nice an simple and not
dyanmic.
This would be easy to do in SQL, using an insert with...
Jonathan
|
02-22-2010 04:23 AM
Jonathan | 0 | 392 |
| | | I'm implementing the ClientAccess example against the Analysis
Services Tutorial and find the code only works if I am logged in as
Administrator....
DataForest
|
02-20-2010 02:06 PM
DataForest | 0 | 331 |
| | | Hello,
I'm writing the client application connecting with SSAS 2005 with
Adomd.net. Because we have external users we are using...
Piotr J
|
02-19-2010 03:00 AM
Lars Heinemann | 1 | 437 |
| | | I'll apologize in advance for asking something that may have already
been answered, but I've searched and can't find a solution.
I am running SQL...
IT
|
02-18-2010 12:25 PM
IT | 0 | 258 |
| | | Good Evening, All!
I have a cube with Sales Measure Group and Rates Measure Group. Sales fact
table contains sales number on daily level, for...
Pasha
|
02-17-2010 08:23 PM
Pasha | 0 | 513 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the...
Mia
|
02-17-2010 06:11 PM
Mia | 0 | 310 |
| | | Hi
I have created a .NET project that successfully creates dimension data
filters for a Role in SQL 2008. I use the AdomdClient to build a tree...
Jonas
|
02-17-2010 02:38 AM
Jonas | 0 | 247 |
| | | Analysis Services 2008 seem to have a bug that prevents KPI parent info from
being displayed. You can see this by running the statement below in...
Igor Krupitsky
|
02-13-2010 02:50 PM
Igor Krupitsky | 0 | 362 |
| | | Hello,
We are working with the add-in excel 2003 for analysis services, and suddenly (since january 2010 i think) it is not possible anymore to...
pascal gineste
|
02-11-2010 08:05 AM
pascal gineste | 0 | 356 |
