Recent content by justins57

If the RelationshipType = Rigid and the attributes change, you will get an error. If the RelationshipType = Rigid and the attributes do not change, the ProcessUpdate will not drop the aggregations. If the Relationship = Flexible and the attributes change, a ProcessUpdate will drop the...

Also, you may need to filter the Years so that only Years with data are returned.

I would use the WITH MEMBER [Date Transaction].[Date Transaction].[CurrentYear] as 'Tail([Date Transaction].[Date Transaction].[YearNo].Members).Item(0).Item(0)' SELECT [Measures].[GrsIncLR%] on 0 from PremiumsAndClaims WHERE [Date Transaction].[Date Transaction].[CurrentYear];

Ovatvvon, Full control (Administrator) Assignment to the Full control role gives complete access to the database, including data, schema, processing, and operations. Administrators can also manage security roles. Process database The Process database role allows SSAS processing. This means a...

Jeff, I found this explanation online, hope it helps. First of all, you need to change PivotTable options to enable the display of calculated members (check PivotTable Tools / Options / Options / Display / Show calculated members from OLAP server). When you do that, you choose to get all...

Is there more to the MDX than the simple select query at the top of the exception?

I tried the Rank function, but it doesn't do what I needed. I ended up adding a Row column to my grid. Thanks for feedback.

Misko, Try this query. WITH SET [TOP 1] AS 'TopCount ([Customers].[City].members, 3,[Measures].[Unit Sales] )' SET [TOP 2] AS 'Generate({[TOP 1]},TopCount (Descendants([TOP 1].currentmember, 1), 2, [Measures].[Unit Sales]))' SET ColSet As 'Crossjoin({[Unit...

Does anyone know an easy way to include the Row Number in the dataset results? I am hoping to get something like this: Row Store Sales 1 NE #11 10,000 2 SE #3 200 3 WC #22 5,000 Thanks, Justin

Hungry, MDXer is correct. There is no Case Statement in AS 2000, there will be in AS 2005. The only way to do this is with the IIF statement - IIF(test, true expression, false expression). Justin

Kasi, How are you partitioning the Cube, by Time or some other dimension? When you rebuild the Partition can you review the SQL it is using, maybe that will help answer your question. Justin

Hi, When you first install AS 2000, its repository is the Access DB at the location specified in your connection string. Typically, you want to migrate the repository to a SQL DB for growth reasons. In your case, it sounds like you have two versions of AS going. Did you have SQL 7.0...

BK, Yes, you can do this. Look at the NonEmptyCrossjoin function to only use days with a headcount value and the Avg function to give you the average for the headcount. Something like this: MEMBER [Measures].[Avg Headcount] As...

Mark, Is it timing out or failing to process. I've seen the process just quit running and this is sometimes caused by Backups or Virus Scans. This seems to be a temporary condition and corrects itself the next time you rebuild the Cubes. Other times the OLAP database becomes corrupt and you...

MT, While modeling your dimensional data from reports is a start there are many pitfalls to avoid. I recommend you visit the Ralph Kimball website to review design tips for a good dimensional model. He is the leading authority on Dimensional Modeling. Here is the link...