Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Loops and Contexts
- Thread starter Kike007
- Start date
Obviously your universe does not include a loop , so there is no auto-detection of possible contexts.
If you have 2 fact-tables joined through a dimension table you can create a context for each facttable.
(use listmode)
Look into the 'Multiple SQL statements' bit in the designer guide how you can use a single SQL to give 2 synchronized datacubes containing measures from 2 contexts.
If your query should return other objects than measures , than consider "linked dataproviders"
T. Blom
Information analyst
tbl@shimano-eu.com
If you have 2 fact-tables joined through a dimension table you can create a context for each facttable.
(use listmode)
Look into the 'Multiple SQL statements' bit in the designer guide how you can use a single SQL to give 2 synchronized datacubes containing measures from 2 contexts.
If your query should return other objects than measures , than consider "linked dataproviders"
T. Blom
Information analyst
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question