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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lochew
  • Content: Threads
  • Order by date
  1. lochew

    Date order from ascending to descending

    Hey Everyone, I’m just looking to find out if there is a switch or option that can be enabled within MSAS 2000 in order to change the date order from ascending to descending. I have a flat date that pulls 2004 -2006 dates (24 month rolling) and want MSAS to display the dates in a descending...
  2. lochew

    Limiting dimensional data that is only relative to the fact data?

    Hey Everyone, I wanted to know if there is a way to limit the dimensional level data that is only relative to the fact data. Example: Within a dimension call store I have a listing of all my stores Store1, Store2, Store3. If I only have Fact data for Store1 how can I make only this store...
  3. lochew

    Date Dimension Question (Only display lowest level data)

    Hi, I have a requirement to build a date dim within MSAS 2000 that will only display the day level values. They still want the date dim level structure Example: Y/Q/M/D but want the Year /Quarter and Month levels to have NO values associated with them. The only values will be at the day level...
  4. lochew

    New to MSAS

    Does anyone know of a way to display a numeric value not from a Fact Table as a measure and not have it aggregate. My thought is an External rollup within Cognos Transformer. If someone can povide an example that would be great. I have another question concerning date filters example: Between...

Part and Inventory Search

Back
Top