Microsoft SQL Server Analysis Services 2008
Questions tagged [ssas-2008]
205 questions
11
votes
4 answers
Trying to process the cube but getting the error at impersonation information
I have built a cube in Business Development Intelligent Studio(BIDS) using some database with the name 'Test_cube' which consists of Products dimension table, customers dimension table and orders fact table.
The products table attributes…
Manu'sa Bora
- 131
- 1
- 1
- 13
7
votes
3 answers
Creating SSAS 2008 cube partitions using Powershell?
How can we create SSAS 2008 cube partitions using Powershell?
Puneet Tripathi
- 71
- 2
7
votes
1 answer
SSAS cube with multiple DB
I have 3 databases with the same structure, but different data, since they are from different clients.
Now, I have an existing SSAS project. Its Data Source Views, Cubes and Dimensions can only use or access one DB.
What I want is to be able to use…
Raii
- 303
- 1
- 4
- 15
7
votes
3 answers
How to add new Dimension Attributes to the existing dimension through BIDS
I have a customer dimension. While creating cube and defining dimensions the default attributes will come along with the cube creation. I want to add some more attributes after creating the dimensions. How to do this. I tried with "Add Business…
Searcher
- 1,845
- 9
- 32
- 45
6
votes
1 answer
MDX SSAS - Max Date in Measure
Just need to get MAX date in ALL my Measures in the Cube. For instance, DateID is a Dimention, [Measure].[First Measure],...,...,[Second Measure].
How to get list of MAX(DateID) from all Measures in my Cube.
user2744070
- 61
- 1
- 2
5
votes
1 answer
Filtering MDX query with current year & month using Now()
How can I filter data in MDX with current Year & Month?
What I did so far is:
WHERE strtomember{ [Time Dim].[FSCL YEAR].&["+Format(now(), "yyyy")+"], [Time Dim].[FSCL MONTH].&["+Format(now(), "m")+"] }
but it is not working.
Aditya
- 2,299
- 5
- 32
- 54
4
votes
1 answer
How to find list of databases on Microsoft Analysis Server(SSAS)
I want to know if I can find out list of analysis databases on an Analysis Server by simply writing a query. I am working on SQL Server 2008.
Niraj
- 1,782
- 1
- 22
- 32
4
votes
3 answers
Accessing SSAS via HTTP
I have followed all the steps correctly present in
http://msdn.microsoft.com/en-us/library/gg492140.aspx
I am trying to connect to SSAS 2008 via IIS (HTTP). My SSAS is on Machine 1. My excel 2010 client is on Machine 2. I have enabled basic…
aviundefined
- 802
- 2
- 10
- 25
3
votes
1 answer
SSAS Cube processing logs
Where are SSAS cube processing (not error, not flight recorder) logs stored?
We have a SQL Agent Job running a SQL Server Analysis Services command. In there is some DMX which processes each dimension then processes the cube database (containing two…
Nick.Mc
- 18,304
- 6
- 61
- 91
3
votes
1 answer
Add new users in SSAS security
I want to add users in SSAS security using following XMLA script.
DECLARE @CreateUserInSsasXMLA VARCHAR(MAX) =
'
…
Mukund
- 1,679
- 1
- 11
- 20
3
votes
1 answer
MDX How do you create a variance and variance % in a report
Using AdventureWorksDW2008R I have the following DataSet
SELECT NON EMPTY {
[Measures].[Sales Amount], [Measures].[Total Product Cost], [Measures].[Internet Sales Count]
} ON COLUMNS, NON EMPTY
{
([Order Date].[Calendar Year].[Calendar…
John
- 275
- 1
- 4
- 14
3
votes
1 answer
MDX - Retrieving a level of members currently used in where clause
I have a simple data cube with organization structure hierarchy defined. In my calculations inside the cube I would like to have different calculations depending on which level of organization items is currently used in WHERE clause in MDX query.…
Bartek Boro
- 155
- 1
- 3
- 11
3
votes
2 answers
MDX for Zero months in last 12 = Number of zero transacting months in the last 12 months rolling window
I am working on MDx query to count the number ZERO txn for each product for last 12 months from today's date. Prepared MDX query for Adventure works fine but my 2nd query running on my Acutal cube working correctly.
Can you please help me out to…
Niel
- 51
- 6
3
votes
2 answers
How many Axis can we use in MDX practically?
I heard about there are around 128 Axis in MDX.
AXIS(0) or simply 0 – Columns
AXIS(1) or simply 1 – Rows
AXIS(2) or simply 2 – Pages
AXIS(3) or simply 3 – Sections
……….
……….
So far I have used only two of them, Column (0) & Row (1).
I am just…
Aditya
- 2,299
- 5
- 32
- 54
3
votes
2 answers
Model a relationship between two fact tables
I have a Sales fact table, an Orders fact table (both line level detail), and two date roleplaying dimensions (from the Date dimension) for Order Date and Transaction Date.
I'm trying to get to a point where you can view sales measures by order date…
Lefty
- 426
- 3
- 10