referenced relationship error

I try to add dimension with referenced relationship. I defined everything like explaination in Books online, but when I try to save cube, I always get message:

"Cube 'Cube' cannot be saved because of the following errors:

Errors in the metadata manager. The 'Key' intermediate granularity attribute of the'IntDim'

measures group dimension does not have an attribute hierarchy enabled."

I enabled this attribute hierarchy for Key... but....

Anybody who can help?

When I tried these basic steps using the Adventure Works sample it worked for me. If you remove the dimension relationship and try to re-create it after saving the dimension with the key enabled, does the problem still occur? If so, could you send me the project files in a Zip?|||

How my problems started...

First of all, when I migrate OLAP DB, in one cube I had relation (referenced) by two fields in tables. I don't know is it supported in AS 2005. I think no.

This is my main question.

After that I try to do several different thinks, explaned in Books on-line (attributes, new named calculation...), but without good results... Unfortunatly, I spend two days to solve this problem, end on the end I changed this relationship between tables (replaced referenced with regular relationship) on the AS 2000 and made migrated again.

At the moment I have not project because I made new migration, but I will try to re-create all story and send to you..

I send to me proper your e-mail adress

|||

Here's my email. Just replace the "-" with an "@.".

Matt.Carroll-Microsoft.com

|||

Matt Carroll wrote:

Here's my email. Just replace the "-" with an "@.".

Matt.Carroll-Microsoft.com

Or you can send it directly to me. "Sasha.Juric" with same domain name as Matt's.

|||When I try to do it from the beginning, everything is ok. But when I migrate old Datebase in AS, I have problem. when i have time I re-craete it. But stay the question, if I use two fields in referenced relationship, does AS 2005 support it

referenced relationship error

I try to add dimension with referenced relationship. I defined everything like explaination in Books online, but when I try to save cube, I always get message:

"Cube 'Cube' cannot be saved because of the following errors:

Errors in the metadata manager. The 'Key' intermediate granularity attribute of the'IntDim'

measures group dimension does not have an attribute hierarchy enabled."

I enabled this attribute hierarchy for Key... but....

Anybody who can help?

When I tried these basic steps using the Adventure Works sample it worked for me. If you remove the dimension relationship and try to re-create it after saving the dimension with the key enabled, does the problem still occur? If so, could you send me the project files in a Zip?|||

How my problems started...

First of all, when I migrate OLAP DB, in one cube I had relation (referenced) by two fields in tables. I don't know is it supported in AS 2005. I think no.

This is my main question.

After that I try to do several different thinks, explaned in Books on-line (attributes, new named calculation...), but without good results... Unfortunatly, I spend two days to solve this problem, end on the end I changed this relationship between tables (replaced referenced with regular relationship) on the AS 2000 and made migrated again.

At the moment I have not project because I made new migration, but I will try to re-create all story and send to you..

I send to me proper your e-mail adress

|||

Here's my email. Just replace the "-" with an "@.".

Matt.Carroll-Microsoft.com

|||

Matt Carroll wrote:

Here's my email. Just replace the "-" with an "@.".

Matt.Carroll-Microsoft.com

Or you can send it directly to me. "Sasha.Juric" with same domain name as Matt's.

|||When I try to do it from the beginning, everything is ok. But when I migrate old Datebase in AS, I have problem. when i have time I re-craete it. But stay the question, if I use two fields in referenced relationship, does AS 2005 support it

Reference Materials

Reference Materials
I am having a hard time finding good reference materials for Reporting
Services; especially information online. For one I canâ't find a good resource
for writing expressions, examples, tutorials etc. Just the other day I saw
the use of â'vbcrlfâ' in an expression, but when looking for information on it
I canâ't find a single thing. Iâ'm really at a loss as to what can or canâ't be
done. Anyone know of any good websites on MS Reporting Services?Hi Tome:
Do you have the documentation material?
http://www.microsoft.com/downloads/details.aspx?familyid=5e550d73-8f35-435e-bb71-c8573a1cdbdb&displaylang=en
--
Scott
http://www.OdeToCode.com/
On Sun, 10 Oct 2004 09:45:03 -0700, Tome73
<Tome73@.discussions.microsoft.com> wrote:
>Reference Materials
>I am having a hard time finding good reference materials for Reporting
>Services; especially information online. For one I can?t find a good resource
>for writing expressions, examples, tutorials etc. Just the other day I saw
>the use of ?vbcrlf? in an expression, but when looking for information on it
>I can?t find a single thing. I?m really at a loss as to what can or can?t be
>done. Anyone know of any good websites on MS Reporting Services?|||The problem with the documentation on expressions is that they leave out one
very very important fact. Three namespaces are included that you can use in
expressions. For instance you can use anything from microsoft.visualbasic,
system.convert (very very important for expressions) and system.math. This
opens up a whole world of additional functionality. So, go to visual basic
documentation on these namespaces and you will be ready to roll.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tome73" <Tome73@.discussions.microsoft.com> wrote in message
news:83100312-648A-4D36-81D2-19E3A4FAAF30@.microsoft.com...
> Reference Materials
> I am having a hard time finding good reference materials for Reporting
> Services; especially information online. For one I can't find a good
resource
> for writing expressions, examples, tutorials etc. Just the other day I saw
> the use of "vbcrlf" in an expression, but when looking for information on
it
> I can't find a single thing. I'm really at a loss as to what can or can't
be
> done. Anyone know of any good websites on MS Reporting Services?
>