How to create following cube?

Posted by Itsgkiran on Stack Overflow See other posts from Stack Overflow or by Itsgkiran
Published on 2010-03-26T09:35:22Z Indexed on 2010/03/26 9:43 UTC
Read the original article Hit count: 205

Filed under:

cubes

|

mdx

Hi!

For example...........

Database Table:

     BatchID    BatchName      Chemical      Value
--------------------------------------------------------
     BI-1       BN-1           CH-1             1
     BI-2       BN-2           CH-2             2
--------------------------------------------------------

I need to display following cube

                  BI-1             BI-2
                  BN-1             BN-2
 -----------------------------------------
   CH-1           1                null
 ------------------------------------------
   CH-2           null             2
 ------------------------------------------

Here BI-1,BN-1 are two rows in a single columns i need to display chemical value as row of that.

What is query MDX query for this.

Could Please help me to solve this problem.

Thank You.

© Stack Overflow or respective owner

Related posts about cubes

How to speed up marching cubes?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using this marching cube algorithm to draw 3D isosurfaces (ported into C#, outputting MeshGeomtry3Ds, but otherwise the same). The resulting surfaces look great, but are taking a long time to calculate. Are there any ways to speed up marching cubes? The most obvious one is to simply reduce the… >>> More
SSRS Drillthrough for SSAS cubes, how to pass a parameter to an MDX dataset

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Yesterday I had a chat with my boss about drillthrough reports. I told him that with SSRS 2008 it can be done easily. Yep, I was right in terms of a SQL Server data source (or other relational I presume) but it cost me almost a day to figure out how to do it if you have two reports based on an SSAS… >>> More
"Marching cubes" voxel terrain - triplanar texturing with depth?

as seen on Game Development - Search for 'Game Development'
I am currently working on a voxel terrain that uses the marching cubes algorithm for polygonizing the scalar field of voxels. I am using a triplanar texturing shader for texturing. say I have a grass texture set to the Y axis and a dirt texture for both the X and Z axes. Now, when my player digs downwards… >>> More
Producing a smooth mesh from density cloud and marching cubes

as seen on Game Development - Search for 'Game Development'
Based on my results from this question I decided to build myself a 3D noise map containing float values in place of my existing boolean point values. The effect I'm trying to produce is something like this, rather than typical rolling hills; which should explain the "missing cubes" in the image below… >>> More
Texturing a mesh generated from voxel data

as seen on Game Development - Search for 'Game Development'
I have implemented the Marching Cubes algorithm to display an isosurface based on voxel data. Currently, it is displayed with triplanar texturing. I'm working with unity, so I have a material with the triplanar shader attached. Now, the whole isosurface is rendered using this material. And thats my… >>> More

Related posts about mdx

MDX Studio download #mdx #ssas

as seen on SQL Blog - Search for 'SQL Blog'
Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com. It was a sad news, and it is… >>> More
MDX: Problem filtering results in MDX query used in Reporting Services query

as seen on Stack Overflow - Search for 'Stack Overflow'
Why aren't my results being filtered by the members from my [Group Hierarchy] returned via the filter() statment below? SELECT NON EMPTY {[Measures].[Group Count], [Measures].[Overall Group Count] } ON COLUMNS, NON EMPTY { [Survey].[Surveys By Year].[Survey Year].ALLMEMBERS… >>> More
Stairway to MDX - STEP 1: Getting Started with MDX

as seen on SQL Server Central - Search for 'SQL Server Central'
To learn MDX, there is really no alternative to installing the system and trying out the statements, and experimenting. William Pearson, the well-known expert on MDX, kicks off a stairway series on this important topic by getting you running from a standing start. NEW! SQL… >>> More
Converting #MDX to #DAX and PowerPivot Workshop online #ppws

as seen on SQL Blog - Search for 'SQL Blog'
I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate”… >>> More
Attribute Overwriting in MDX

as seen on SQL Blog - Search for 'SQL Blog'
Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script and if you tried to customize the DateTool… >>> More