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 Mike Lewis 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. niraj2000

    Calcualted Member Query !!

    I am using SQl Server 2000 Analysis Services for building cubes and MS Data Analyzer. Data Analyzer does not provide support for MDX expression except in the form of Calculated members feature of Sql server OLAP. I have 4 dimensions. Consider A, B, C, D and a measure X. I want to write a...
  2. niraj2000

    Analysis Server Cube / Data Analyzer Query

    I am using Sql server 2000 Analysis Service and MS Data Analyzer as my OLAP reporting tool. I have 4 dimensions built in cube and displayed in my data analyzer view. For eg, consider the dimensions as A, B, C, D. I have 3 measures. For eg, X, Y, Z. Consider a scenario where I have all 4...
  3. niraj2000

    Help with MDX query !!

    For example consider following table: product price (calculated measure) A 2 2 B 3 2+3=5 C 1 5+1=6 D 3 6+3=9 E 1 1+9=10 I want to create a calculated measure which does the above summations ...
  4. niraj2000

    How can I create a dimension using multiple dimension at same level?

    I have a table "Test". In the Test table, there are different columns, "TestTypeCategory", "IndividualTest1", "IndividualTest2" and so on... For each "TesttypeCategory" there are values for "IndividualTest1", "Test2" and so...
  5. niraj2000

    How do I dynamically increment OLAP cube in SQL server ?

    Sorry posted in the wrong forum !!
  6. niraj2000

    How do I dynamically increment OLAP cube in SQL server ?

    I have created a cube in using Analysis Manager in Sql Server 2000. As the database grows, I want the cube to update itself. This can be done manually. But I want to automate for reporting capabilities. Is anyone aware of such a facility in Analysis Manager of Sql Server 2002 for auto updates ?
  7. niraj2000

    How do I dynamically increment OLAP cube in SQL server ?

    I have created a cube in using Analysis Manager in Sql Server 2000. As the database grows, I want the cube to update itself. This can be done manually. But I want to automate for reporting capabilities. Is anyone aware of such a facility in Sql Server 2002 for auto updates ?

Part and Inventory Search

Back
Top