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...
Scot J Reagin
sreagin@hitachiconsulting.com
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,...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
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
Scot J Reagin
sreagin@hitachiconsulting.com
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...
Scot J Reagin
sreagin@hitachiconsulting.com
December 12, 2002 at 12:35 pm
Hi Manny -
What client tool are you using?
Scot J Reagin
Scot J Reagin
sreagin@hitachiconsulting.com
December 10, 2002 at 6:43 pm
Viewing 15 posts - 1 through 15 (of 36 total)