Questions tagged [msas]
15 questions
3
votes
2 answers
Escaping special characters in an MDX Query
I'm building a BI dashboard for my client. Our data is stored in an analysis server cube. Overall things work great, but a smartalec tester decided to create a merchant with the name `~!@#$%^&*()_+-=[]{}|;':"<>?,./ The name shows up just fine as…
Jake
- 906
- 10
- 23
3
votes
3 answers
How to view MS SSAS 2005 sessions and queries
When browsing the cube in Microsoft SQL Server Analysis Services 2005, I would like to peek at the MDX (supposedly) queries generated by client access tools such as Excel. Is there a tool or method that enables me to do just that?
I'm really looking…
ttarchala
- 4,277
- 2
- 26
- 36
2
votes
1 answer
What is the best way to model a ragged hierarchy in SSAS for both ROLAP and MOLAP?
I'm currently trying to model a ragged hierarchy in SSAS and I'm stuck.
First, I was trying to model it like so:
ItemKey,Level0Key,Level1Key,Level2Key
Item1,Lvl0-1,Lvl1-1,Lvl2-1
Item2,Lvl0-1,Lvl1-1,Lvl2-1
Item3,Lvl0-1,Lvl1-1,Lvl2-2
**Item4,Lvl0-1, ,…
Eli
- 1,315
- 1
- 16
- 29
1
vote
0 answers
"Errors in the encryption library" When restoring Analysis Services Database
I have a AS Database (SQL Server 2005). I need to restore the database in a SQL Server 2014.
When I'm trying to restore the database I have this error:
File system error: The following error occurred while opening the file
'\?\C:\Program…
Guido Caffa
- 1,201
- 1
- 12
- 22
1
vote
0 answers
You cannot call a method on a null-valued expression in PowerShell
This is my code in PS:
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices.Tabular")
$serverName = "panya\taylor";
$databaseName = "FreshDesk";
$tableName = "Metrics";
$measureName = "TestAuto";
$measureExpression = "SUMX (…
DNac
- 2,663
- 8
- 31
- 54
1
vote
1 answer
MDX query with nested aggregations
WITH
MEMBER [Measures].[newCalculatedMeasure] AS
Sum
(
Filter
(
Descendants
(
[Date].[28 Days Month Calendar].CurrentMember
,2
,LEAVES
)
,
…
laxmi
- 13
- 3
1
vote
4 answers
Why isn't SSAS loading any measure data for my cube?
Background:
I'm writing a data provider that SSAS will use to get data from a third-party system.
I wrote a tool that will build cubes, dimensions, measure groups and measures based on the configuration of the third-party system using AMO.
Now, in…
Eli
- 1,315
- 1
- 16
- 29
1
vote
1 answer
Script to find absolute path / Location of Analysis Services Database?
Whenever I restore an AS Database, the DB files are created in a new folder by name DBName_[1-n] wherethe number is incremented by 1 after every restore. I am currently looking for a script to copy the files[or this ASDBName_[n]] dynamically to…
Vardhan
- 402
- 5
- 13
1
vote
0 answers
Can msmdpump be used for connecting to local cubes?
I am trying to configure IIS to connect to a local cube(.CUB file) through msmdpump so I can query the local cube using XMLA. I changed msmdpump.ini to look like this:
"C:\Adventure Works.cub"
…
user2574274
- 11
- 1
1
vote
0 answers
Total member for the hierarchy with top/bottom x values filter
I'm using MSAS 2008 with the Adventure Works DW. Here's the structure for the slice I'd like to get using MDX query:
[Product].[Style], [Product].[Product Categories], [Measures].[Discount Amount], [Measures].[Reseller Order Quantity] on…
iamjager
- 11
- 1
1
vote
2 answers
Multiple kinds of payees
I make payments to various kinds of payees and I'm wondering whether I should create a dimension of each kind of payee and have multiple foreign keys in my fact table, or conflate the various kinds of payees via a type attribute and have a single FK…
ekkis
- 9,804
- 13
- 55
- 105
1
vote
3 answers
How to groupby and filter on the same dimension in MDX
I want to create a barchart with a bar for each month and some measure.
But i also want to filter on a range of day which might not completly overlap some of the month.
When that happen I would like the aggregate count for those month to only…
skyde
- 2,816
- 4
- 34
- 53
0
votes
2 answers
MSAS m2m attribute not resolved as expected
I'm no expert in MSAS Cube so may be this is obvious, but this is blocking an important feature in our team.
We have a fact table of "Indicators" (basicaly values from a calculator), that are computed for a specific date. indicators have a…
Quentin
- 117
- 12
0
votes
1 answer
OLAP, if dimension has 'unknown' member, then only it is displayed if no measures added. Any ways to fix it?
I have cube in Microsoft Analysis Services with several dimensionsions and measures.
When I(in cube browser, or through pivot tables in excel) try to drag dimension's attribute to grid with no measures added the following happens:
if there were…
anonyms
- 1
- 1
0
votes
1 answer
XML/A error response: what is the standard?
I maintain a library that provides XML/A access trhough javascript: https://github.com/rpbouman/xmla4js
Mostly it works ok, but I would like to improve handling of error responses. As far as I understand the XML/A spec corectly, error responses take…
Roland Bouman
- 31,125
- 6
- 66
- 67