Top "Ssas-2008" questions

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 …

sql bids ssas-2008

MDX: IIf condition on the value of a dimension is always false

I am trying to produce a different output in a column dependent on whether the value of a dimension [Scenario].[…

sql-server ssas mdx ssas-2008 iif

Calculated Member based on dimension attribute value

I want to make some Calculated Measures in my cube that conditionally use a value from the measure table, based …

mdx dimension ssas-2008

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 …

sql-server ssas ssas-2008

SSAS Cube processing logs

Where are SSAS cube processing (not error, not flight recorder) logs stored? We have a SQL Agent Job running a …

ssas ssas-2008

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{ […

ssas mdx olap-cube ssas-2008

How to sum a calculated measure?

I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I …

ssas mdx data-warehouse olap ssas-2008

Filtering a Dimension Relative to a CurrentMember in MDX

I'm having a bit of trouble accomplishing something that I think should be relatively straightforward in MDX. I would like …

ssas mdx olap ssas-2008

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 …

ssas olap olap-cube ssas-2008

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 …

ssas cube bids olap-cube ssas-2008