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: *

  1. Patlin

    Your opinion on star schema dimension

    I agree with samonsey. You should fix this in the staging area when you load the dimension and fact tables. But Cognos product Transformer wich builds Cognos cubes fixes this fore you. But that is not always a good thing. Because then you will build cubes that actually contains data that is not...
  2. Patlin

    1:n relationship fact to dimension

    Do you not mean that there is a n:n relationship between the fact table and dimensiontable? In that case you have a select distinct count problem. And they are hard. Microsoft has function for that. But it can be slow.
  3. Patlin

    Measures for different Dimensions

    Create a calculated measure called Sales_blablabla with the formula: ValidMeasure ([Measures].[Sales]) I had the same problem and tried to use the cognos solution but found this solution instead hope this will work Best Regards Patrik
  4. Patlin

    Show Measures everywhere in a Virtual Cube in analysis services

    I found the answere. Create a calculated measure called mynewmeasurethatworks everywhere with the formula: ValidMeasure ([Measures].[myoldmeasurethatdonotworkeverywhere])
  5. Patlin

    Show Measures everywhere in a Virtual Cube in analysis services

    Hi I Have several cubes with measures that are combined into one virtual cube. The shared dimension are: Time (Levels: year,quarter,month,day) CinemaTheater (Levels: Region,city,Cinema,Showroom) Daytype (onelevel:{weekday,weeken}) Channel (onelevel: {wap,internet,manual}) Movie (Levels...

Part and Inventory Search

Back
Top