MDX. Slowly changing value with adjustment. ADOMD.Net. MDX usage in C#

db_developer

Rate me:

4.50/5 (4 votes)

1 Dec 2009CPOL12 min read

38.8K

1.4K

MDX query for Get last valid value for measure before the date and then calculate all values that contribute to this value till given date. ADOMD.Net. MDX usage in C#.

mdx_slowlychangingvaluewithadjustments_sources_plus_demolight.zip
- Sources
  - AmicusAnalysisServices
    - AmicusAnalysisServices.sln
    - AmicusAnalysisServices.suo
    - AmicusAnalysisServices
      - Amicus Dev.cube
      - Amicus Dev.ds
      - Amicus Dev.dsv
      - Amicus Dev.partitions
      - AmicusAnalysisServices.database
      - AmicusAnalysisServices.dwproj
      - AmicusAnalysisServices.dwproj.user
      - bin
      - Location.dim
      - obj
        
        Development
      - Product.dim
      - Time.dim
      - view.sql
  - databaseSource.bak
  - GetStockLevel
    - GetStockLevel.sln
    - GetStockLevel.suo
    - GetStockLevel
      - bin
      - GetStockLevel.csproj
      - obj
      - OLAPConnectionDesigner.cs
      - OLAPConnectionDesigner.designer.cs
      - OLAPConnectionDesigner.resx
      - Program.cs
      - Properties
        
        AssemblyInfo.cs
        
        licenses.licx
        
        Resources.Designer.cs
        
        Resources.resx
        
        Settings.Designer.cs
        
        Settings.settings
      - StockTakeLevel.cs
      - StockTakeLevel.Designer.cs
      - StockTakeLevel.resx
  - MDX
    - GetLastBiggestMemberButLessThanGiven.mdx
    - StocktakeQtyAllValues.mdx
    - StocktakeQtyScalarRecurseUsage.mdx
    - StocktakeQtyScalarTailUsage.mdx
mdx.zip
- MDX
  - GetLastBiggestMemberButLessThanGiven.mdx
  - StocktakeQtyAllValues.mdx
  - StocktakeQtyScalarRecurseUsage.mdx
  - StocktakeQtyScalarTailUsage.mdx


Microsoft Visual Studio Solution File, Format Version 9.00
# Visual Studio 2005
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "GetStockLevel", "GetStockLevel\GetStockLevel.csproj", "{C703CAF7-3060-4931-BDD8-41A3EE752E1C}"
	ProjectSection(WebsiteProperties) = preProject
		Debug.AspNetCompiler.Debug = "True"
		Release.AspNetCompiler.Debug = "False"
	EndProjectSection
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{C703CAF7-3060-4931-BDD8-41A3EE752E1C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{C703CAF7-3060-4931-BDD8-41A3EE752E1C}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{C703CAF7-3060-4931-BDD8-41A3EE752E1C}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{C703CAF7-3060-4931-BDD8-41A3EE752E1C}.Release|Any CPU.Build.0 = Release|Any CPU
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

db_developer

Database Developer Freelancer

Ukraine

MS SQL Server Database Developer with 7+ years experience

Technologies/languages: Business Intelligence, SQL, MDX, VBA, SQL Server, Analysis Services (SSAS), Reporting services (SSRS), Integration Services (SSIS), DataWarehouse.
Also: economic background.

Feel free to contact me for rates and details.

MDX. Slowly changing value with adjustment. ADOMD.Net. MDX usage in C#

License

Comments and Discussions