Все вопросы: [ssas]

131 вопросов

похожие теги: dmx-ssasssas-2008ssas-2012
2
голосов
1ответов
1754 просмотров

PerformancePoint Dashboard Designer Error when creating a Filter - No Filter Data Retrieved

I'm attempting to create a filter using PerformancePoint's Dashboard Designer. After going through the wizard, however, the "Confirmation" page displays the following message: No filter data retrieved Warning 1: Filter was created but no data was retrieved. To resolve the problme, fo...

0
голосов
1ответов
55 просмотров

Resources for Analysis Server and Reporting Services

What are the best resources for Analysis Server and Reporting Services in your opinion? Community based or otherwise.

0
голосов
1ответов
1218 просмотров

DateTime in SSAS

I have a DateTime column in my Time dimension table. I want to display this as just MM/DD/YYYY and hide the time component (which is 00:00:00 anyways). How do I do this?

1
голосов
3ответов
641 просмотров

MDX geographic distance calculation

I'm using SQL Server 2005 Analysis Services and I'm trying to calculate distance inside of an MDX query - so that I can get counts of the items that are near my current location. I've created a dimension with Latitude & Longitude, and have also created a .NET assembly to do the math - but am...

1
голосов
2ответов
792 просмотров

SSAS - Moving Annual Total

Environment: SQL-Server-2005, SSAS 2005 I am using the following formula to create a Moving Annual Total SUM ({[Time].CurrentMember.Lag(3):[Time].CurrentMember}, [Measures].[TRx Quantity]) The same column [Measures].[Trx Quantity] is used in other calculations and it works fine. This one, how...

0
голосов
1ответов
345 просмотров

How to show last value of a column in MS Analysis Service?

I have a cube with several dimensions. I need (a measure, calculation, whatever...) to show last value of a column, assuming the table is sorted by another column. Something like: SELECT TOP 1 column_1 FROM table_1 WHERE «The user's selected dimentions will work as a filter» ORDER BY column_2 ...

0
голосов
1ответов
410 просмотров

Moving Annual Total SSAS

I have a cube and I want to create a MAT column. This column is then expected to show up in the same way as a regular metric would. How do I create a column that is a Moving Annual Total in SSAS? A walkthrough / demo would work as well.

0
голосов
3ответов
421 просмотров

SSAS - process top 10K rows of fact table

My environment: SQL Server 2005 for database and SQL Server 2005 Analysis Services. I have a fact table of 78M rows. I want to only process the first 10K rows in my development phase. Other than removing the rows from my Fact table, is there another way of achieving this?

3
голосов
3ответов
677 просмотров

Guidelines for determining the maximum frequency to process an SSAS cube?

We have an Analysis Services cube that needs to be as real-time as possible. It's a relatively small cube that currently takes a couple of seconds to process. Are there any guidelines for this? I'm curious what other folks are doing. Also, what would be the impact of processing the cube too...

1
голосов
2ответов
493 просмотров

the world of MDX queries

I am looking for SSAS cube and MDX (Multidimensional Expressions) sites like our StackOverflow site. Any other resources for SSAS cubes would be welcome as well.

3
голосов
2ответов
1170 просмотров

How to access KPI Value hidden measures via ADOMD.NET?

I'm trying to access the KPI metadata via ADOMD.NET (using MDSCHEMA rowsets) with SQL Server/SSAS 2008. When I get a given KPI VALUE field, for example in Adventure Works, it returns what I believe is the hidden measure associated with the KPI (e.g., [Measures].[Net Income Value]). But the Value...

0
голосов
1ответов
2013 просмотров

SSAS 2008 Dimension Wizard and the Date Template

Does anyone know how to use the Date Template with the BIDS 2008, SSAS Project, Dimension Wizard? I keep getting an error - rightly so, I suppose - "Dimension not generated because it is bound to a time binding" (after having selected Generate a non-time table in the data source, in order to get ...

1
голосов
1ответов
1275 просмотров

Many to many dimension - MDX help needed

I’m pretty new to the many-to-many dimensions but I have a scenario to solve, which raised a couple of questions that I can’t solve myself… So your help would be highly appreciated! The scenario is: There is a parent-child Categories dimension which has a recursive Categories hierarchy with No...

1
голосов
1ответов
1486 просмотров

SSAS aggregation not being used

So I have a fairly hefty cube that won't be much good without aggregations. I'm still in dev phases, so I'm manually attempting usage based agg design. I'm aggregating some of the main queries that we've designed. However, every time I pull these up, it looks like it's reading through each partit...

1
голосов
1ответов
526 просмотров

How do I go about restoring an SSAS 2000 .CAB file using 2008 tools?

I am trying to work out through the sample code that comes with Fast Track to MDX.

1
голосов
1ответов
848 просмотров

Connecting to SQL Server Analysis with a windows user

How can you impersonate a windows user in a connection to an analysis server - using ADOMD.NET? Webserver is next to Analysis server, but they are not in a domain. The webservice running on the webserver needs to access the analysis server as a specific windows account. Is there something I ca...

0
голосов
1ответов
1594 просмотров

Difference between analysis services and business intelligence development studio?

As you might have guessed from the title, I'm really new to analysis services. I've spent the last 5 hours (crazy!) just trying to figure out what is the difference between the analysis services avail. through SSMS and business intelligence development studio avail. through visual studio? Thanks

2
голосов
2ответов
472 просмотров

SSAS 2005: working with database slow after processing

I have a SSAS 2005 database with 10 cubes. When I create the cubes from an XMLA script, it works fast, and I can browse cubes from SSMS, just as I should. After processing the cubes during the night, eveyrthing starts to work VERY slow. Opening cube list in SSMS takes few minutes, and it is like...

1
голосов
1ответов
3046 просмотров

is it possible to have multiple search condition in filter function in MDX

Can there be multiple search conditions in the "filter function" in mdx. If possible how do I put [Measures].[x]> 0 and [Measures].[y] = 0 in filter(set expression, search condition)

0
голосов
1ответов
2400 просмотров

SSAS dimension key as compound key vs char field

For anyone working with SSAS 2008, a question: I have a rather large dimension whose key attribute is a combination of two integer fields. I have the key attribute's Key Columns set up as a collection consisting of the two integer fields, and for the name column I have a WChar field which conca...

4
голосов
2ответов
9161 просмотров

Slowly Changing Fact Table?

Background) I've gone through the process of building a fact table for our inventory data that will in theory act as a nightly snapshot of our warehouse. What is recorded is information such as quantity, weights, locations, statuses, etc. The data is very granular and in many cases not specifical...

0
голосов
1ответов
2583 просмотров

How to slice a factless fact table on time dimension? (SSAS)

Starting with the customary - "please excuse me as this is my first post and i'm a relative beginner" disclaimer, i have the following question... I work for a not for profit campaigning organisation, I've set up an SSAS solution to measure campaigning actions (e.g emailing the priminister) take...

0
голосов
2ответов
894 просмотров

Analysis Services Excel KPI not appearing

I have an analysis services database with an excel front end. At one point I had the KPI coming though to excel 2007 but now I have no option to select them. Is this a known issue?

1
голосов
1ответов
159 просмотров

Why pulling the measures into browser doesn't show even if the resultset has values?

While processing an SSAS cube, the query that I got from processing window like "under SQL queries 1" is producing resultset, but when the processing is done and the measures are pulled into the browser, the values do not show up. What could be the reason?

0
голосов
1ответов
6544 просмотров

Memory error: Allocation failure: not enough storage is available to process this command

I was trying to run the cube script to install the cube-database in the analysis server. I changed the data source to point to the server I wanted, but I got the error as in the title with the error codes Error Code = 0x8007000E, External Code = 0x00000000: I tried the properties of the analysi...

2
голосов
2ответов
1585 просмотров

Cube Calculated Member Question

I'm rather new to SSAS and am completely stumped on how to solve this problem. I have a dimension called Thresholds. Within the Thresholds dimension there are the following Members: [Threshold Year], [Threshold1 Amount], [Threshold2 Amount], [Threshold3 Amount] I also have a measures calle...

5
голосов
2ответов
6693 просмотров

Performance Implications of Calculated Members in SSAS

I'm wondering if there are any performance implications from adding a lot of calculated members to my cube. On one hand, it's nice to have things defined once, located centrally, tested, and available for use from any client which doesn't support MDX. On the other hand, some of these members I'...

0
голосов
1ответов
2079 просмотров

Linked Measure Groups and Local Dimensions

Mulling over something I've been reading up on. According to Chris Webb, A linked measure group can only be used with dimensions from the same database as the source measure group. So I took this to mean as long as two cubes share a database, a linked measure group can be used with a ...

1
голосов
2ответов
2018 просмотров

Opening offline cube from another machine

Here is the steps to my problem: I have a MOLAP cube with MOLAP dimensions on the AS2008 server I connect to it with Excel 2007 and save it in a local cube file (.cub) I disconnect from network, then I try to open the offline cub file through excel. It is successful. I copy the .cub file to ano...

1
голосов
1ответов
3324 просмотров

Sql Server analysis Services 2008 Dynamic dimension security using MDX expression

Some dimension tables in my warehouse: DML Site Id bigint Name nvarchar(256) Primary key (Id) DATA SiteId Name 2 Site 2 3 Site A DML UserSite Username nvarchar(256) SiteId bigint Primary key (Username, SiteId) Foreign key (SiteId) ...