Viewing 15 posts - 1 through 15 (of 36 total)
I don't think there's a hard and fast rule on this question. Some store the repository in the msdb database and an argument could be made that this is...
May 26, 2003 at 9:36 pm
Open the cube in the cube editor. Right click on the Calculated Member folder in the object list. This will put you in the Calculated Member Builder.
From here,...
May 26, 2003 at 9:29 pm
Hi Ryan -
What is the data type of the original field?
The 'potential loss of data' message very often just indicate that the maximum data size of the new type is...
April 27, 2003 at 9:23 pm
Mike -
You don't need a count measure to generate an average - though the count measure will allow you to analyze how many tests were given.
To generate an average measure...
April 13, 2003 at 8:43 pm
Hi Andrew -
I've seen this error before and had the same experience. It seems to be a corruption of the Analysis Services repository and copying or recreating the object...
April 13, 2003 at 8:34 pm
What happens to the aggregation data depends upon the method of update. In cases of Full Reprocess or Refresh Data the aggregation data is emptied and recreated. In...
April 13, 2003 at 8:27 pm
Could you save the package as a .dts (structured) file and email it to me? I'll see if I can put together a quick review/test session.
Scot J Reagin
April 7, 2003 at 12:06 pm
Hmmmm....two thoughts come imediatly to mind:
1. Are SQL Server and Analysis Services on the same service patch? There are some very odd behaviors if the SP#s are out of...
April 7, 2003 at 9:35 am
Sounds like you're on the right track. Only OLAP Administrators can modify AS objects. Add the SQLCmdAgent user to the OLAP Administrators group and give it a try.
If...
April 4, 2003 at 4:05 pm
Michael -
I don't think you'd gain much from a vertical partitioning scheme but your first question is an interesting one.
Partitioning the cube into monthly data stores gives you better processing...
April 4, 2003 at 3:01 pm
Michael -
Are there any other tasks in the package that update Analysis Services objects?
My question is based on this idea: the update you describe modifies a property value of the...
April 4, 2003 at 2:51 pm
afrugone -
Excel should respect the roles defined. So, what you are experiencing is not a deficiency in the tool.
So, let's consider the easy potential causes first:
Are there any other...
April 4, 2003 at 2:45 pm
Calculated Cells is available only in Analysis Services Enterprise and Developer editions.
Is it possible that you are using Standard or Personal SQL Server?
Scot J Reagin
February 3, 2003 at 9:15 am
It sometimes happens that the object repository of Analysis Services has issues which cause individual objects to behave badly. Rather than attempt to hack the repository, it's typically better...
December 12, 2002 at 12:35 pm
December 10, 2002 at 6:43 pm
Viewing 15 posts - 1 through 15 (of 36 total)