you can only use Measures from ther first (factTable).
Create a view to use fields from both. Then you have to add this view to
your query, that you can use it in OLAP. But remember, the join in the view
is an inner join, you get only records which have values in ervery table in
the view.
Michael
>From: ali cetin cetinel <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: [development-axapta] Problem with OLAP service
>Date: Thu, 2 Sep 2004 02:15:19 -0700 (PDT)
>
>i have a problem with the OLAP service..While making a query i added a
>relation between two SQL tables..but when i tried to defined the cube,on
>the Measures tab there wasn't the measures that i wanted to use,which were
>in the second table...i looked up the query examples and i think i added
>the Relation between the tables correctly...
>
>
>---------------------------------
>Do you Yahoo!?
>Win 1 of 4,000 free domain names from Yahoo! Enter now.
>
>[Non-text portions of this message have been removed]
>
>
_________________________________________________________________
Wu�ten Sie, da� Sie Ihren Hotmail-Posteingang auch �ber den MSN Messenger
abrufen k�nnen? http://www.msn.de/messenger Jetzt kostenlos downloaden und
einfach testen!
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
