MDX Expressions - data.oledb.olap
This is a discussion on MDX Expressions - data.oledb.olap ; I have the following three related tables. Trap Table Marks Table PIC_FishMarks Table FishID (PK) ID (PK) MarkID (PK) .. FishID (FK) Acronym .. MarkID (FK) Description .. Count I have created a snowflake dimension called marks usin Description from ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| Trap Table Marks Table PIC_FishMarks Table FishID (PK) ID (PK) MarkID (PK) .. FishID (FK) Acronym .. MarkID (FK) Description .. Count I have created a snowflake dimension called marks usin Description from PIC_FishMarks, which relates back to Trap Table through Marks Table by the Foreign keys listed above. Trap Table contains 10,000 records and Marks Table contains 100 records, I want to create an MDX value that says, if a FishID from the trap Table is not in the Marks Table the a record should be added to the total count with a description of "No Marks". Is this possible, Please let me know if you need additional information and thanks for your help in advance. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Analysis Server, Reporting Services, Calender Control and MDX quer | Database Administrator | sqlserver-olap | 8 | 04-19-2007 09:10 PM |
| logical expressions in mdx query | Database Administrator | sqlserver-olap | 0 | 11-02-2006 11:13 AM |
| How to declare and set a MDX parameter ? | Database Administrator | sqlserver-olap | 1 | 10-12-2006 11:55 AM |
| MDX Query/Caching Questions | Database Administrator | sqlserver-olap | 0 | 09-26-2006 02:29 PM |
| Re: HELP: Getting MDX from OWC | Database Administrator | olap | 1 | 04-02-2004 01:39 PM |
All times are GMT -4. The time now is 05:17 AM.




Linear Mode
