Search results for query: *

Hey MDXer... Is there no other way to perform this task...It's not looking so good...I haven't found much on asc or desc with respect to flat time dims....I guess no one has ever needed this before.... I'm not able to create a physical date dimension table...I already have a time dim within...

Hey MDXer... I'll give it a try....do you know if 2005 has a toggle switch for Ascending or Descending...It would be a cool feature...especially on Date Dims…when you have no more billable time…lol Cheers

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

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

Thanks MDXer...I'll give the Cal Cells a try... Cheers

You may want to look at Member Properties...These values are displayed as strings and can be added to the measures within a cube (MDX Expression) NOTE: Make sure that the end user tool will support the string value as a measure example: Cognos PowerPlay does not support non-numeric values...

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

Thanks johnherman for the info. I was able to get it working by creating the following Calculated Member based off a Member Property field: IIF([Inv Account].CurrentMember.Level.Name ="Account Name",CDbl([Inv Account].CurrentMember.Properties("Target Percent")),Null)/100 This is displaying...

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