dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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 ...



Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 05-29-2007, 05:47 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default MDX Expressions

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
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.

Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

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.