Simulating Parent-Child dimension with data on leaf members only

Introduction

Parent-child dimensions

When SQL Server introduced Parent-Child dimensions with Analysis Services 2000, it came with different options regarding members associated data, also called Data Members.

This option could be set via Members With Data property.

Excerpt from SSAS 2000 BOL: "The Members With Data property indicates whether nonleaf members of a parent-child dimension are allowed to have associated fact table data. By default, nonleaf members are not allowed to have associated fact table data, so the property is initially set to Leaf members only. The related Data Member Caption Template property controls the names of data members when the Members With Data property is set to Nonleaf data visible. For more information about these properties, see Properties Pane (Cube Editor Data View) and Properties Pane (Dimension Editor Data View)".

There were three possible values for Members With Data property: Leaf members only, Nonleaf data visible and Nonleaf data hidden.

Analysis Services 2005 changes

With the coming of SSAS 2005, Leaf members only value for Parent-Child dimensions isn’t implemented anymore.

This shouldn’t be a real issue, as Nonleaf data hidden can be used as a workaround to give the illusion only leaf members have data.

This workaround is satisfying for most of the situations, except for the following case.

When Leaf members only is required

Let’s consider Organization Parent-Child dimension in SSAS 2005 Adventure Works DW sample database.

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture01.png

Let’s assume we have data only for leaf members (i.e. non leaf members are aggregating leaf ones; even if this is not the exact business meaning in the sample).

If we execute the following UPDATE CUBE command at [European Operations] member level:

UPDATE CUBE [Organization] SET ([Organization].[AdventureWorks Cycle].[European Operations])=60

We expect to have an equal distribution of 60 on [France] and [Germany], 30 each. Instead, we get 20 on [France], and 20 on [Germany] (but still an aggregated value of 60).

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture02.png

Where are the missing 20?

Remember our dimension is set with Non leaf data hidden option set (as a replacement to the disappeared Leaf member only option). This means member [European Operations] has its own data, so aggregated [European Operations] has in reality three children (and not two, as shown in query result). That’s where the missing 20 is gone: on [European Operations] Data Member (20+20+20=60).

This is a serious issue in a Budget and Planning context.

One could say the problem shouldn’t occur if the cube is pre-filled with fact data for all Leaf members. An UPDATE CUBE command combined with the USE_WEIGHTED_ALLOCATION option would then distribute data as expected.

The point here is we don’t always have fact data. If a company creates a new division (a new member in the dimension), it will start a budget from scratch, i.e. with no fact data.

So what can we do?

Workaround

Obviously, we must avoid Parent-Child dimensions, and come back to standard ones.

The hierarchy level HideMemberIf property can be used to give the illusion of an unbalanced structure (as with Parent-Child).

Data source

The difficult thing is to get the dimension data source fit the new dimension type.

Our Organization Parent-Child dimension data source had a structure based on a key field (OrganizationKey) and a parent field (ParentOrganizationKey).

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture03.png

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture04.png

With a standard dimension, we need a table structure with as many fields as levels.

This structure change can be handled quite easily if we have control on the data source.

This is not always the case:

  • Data source can already exist when this change is required.
  • Parent-Child table structure must be kept for compatibility and usability reasons.

On the fly transformation

There are different techniques to transform a Parent-Child structure to a hierarchical one.

Many stored procedures have been published on the internet by T-SQL gurus. One of these stored procedures could be executed by a SQL Server Integration Services (SSIS) package before dimension processing.

For some reasons, we may need/want to keep all the logic at SSAS level, without relying on external packages. In this case, our standard dimension data source can be linked to a named query in the Data Source View. Our named query will be defined using a recursive query, which is possible since SSQL 2005 with the use of Common Table Expressions.

Using such recursive query on Parent-Child table structure will result in the following structure and dataset for our Organization dimension data source:

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture05.png

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture06.png

If we analyze in detail the transformed table structure, we notice it’s organized in groups of three fields, one group corresponding to a level:

  • k_Level<N>: OrganizationKey for level <N>, the member key.
  • n_Level<N>: OrganizationName for level <N>, the member name.
  • PercentageOfOwnership_Level<N>: for level <N>, a member property.

For leaf members with a smaller depth, values are duplicated on descendant levels.

Dimension design

Dimension design is straight forward. Each group of fields will be used to create an attribute. Then, attributes will be used to build a user hierarchy.

Finally, the HideMemberIf property will be set for each hierarchy level with value OnlyChildWithParentName. This will make those descendant (see before) levels invisible to the client.

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture07.png

Using it

If we browse the new dimension, it will look the same as the original Parent-Child dimension.

If we execute the same UPDATE CUBE command at [European Operations] member level:

UPDATE CUBE [Organization] SET ([Organization].[AdventureWorks Cycle].[European Operations])=60

We get the expected result, with value 60 equally distributed on [France] and [Germany]:

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture08.png

Conclusion

The lack of a Leaf members only value for Members With Data property in SSAS 2005 can be solved with unbalanced standard dimensions.

Advantages

  • Query performance: it is recommended to avoid Parent-Child dimension, as values are not aggregated.

Drawbacks

  • Process performance: depending on the dimension data source size and depth, recursive query execution can be time consuming when dimension needs to be processed.
  • Display: SSAS doesn’t properly estimate member children count for unbalanced standard dimensions. This can be seen when browsing dimension. On screen shot below, highlighted leaf members not being at the deepest level have an associated [+] symbol, indicating they can be drilled-down (which is not the case).

http://cid-9cf41ea10109e385.skydrive.live.com/embedrowdetail.aspx/Public/Blog/SimulatingParentChilddimension/Picture09.png

Advertisements
This entry was posted in Analysis Services. Bookmark the permalink.

7 Responses to Simulating Parent-Child dimension with data on leaf members only

  1. 旺立 says:

    http://www.batteries-shop.nethttp://www.batterieslaptop.nethttp://www.uk-laptopbattery.comhttp://www.wt-batteries.comhttp://www.cheapteastore.comhttp://www.laptopbatterystore.co.ukhttp://www.batterieslaptop.nethttp://www.batteries-supply.comhttp://www.powertoolsbatteries.co.ukhttp://www.batterygrip.orghttp://www.uk-batteries.co.ukhttp://www.ukbatterystore.co.ukhttp://www.batteries-shop.net/acer-laptop-battery-c-2.htmlhttp://www.batteries-shop.net/apple-laptop-battery-c-3.htmlhttp://www.batteries-shop.net/asus-laptop-battery-c-4.htmlhttp://www.batteries-shop.net/compaq-laptop-battery-c-5.htmlhttp://www.batteries-shop.net/dell-laptop-battery-c-6.htmlhttp://www.batteries-shop.net/fujitsu-laptop-battery-c-7.htmlhttp://www.batteries-shop.net/gateway-laptop-battery-c-8.htmlhttp://www.batteries-shop.net/hp-laptop-battery-c-9.htmlhttp://www.batteries-shop.net/hp-compaq-laptop-battery-c-10.htmlhttp://www.batteries-shop.net/ibm-laptop-battery-c-11.htmlhttp://www.batteries-shop.net/lenovo-laptop-battery-c-12.htmlhttp://www.batteries-shop.net/lg-laptop-battery-c-13.htmlhttp://www.batteries-shop.net/panasonic-laptop-battery-c-14.htmlhttp://www.batteries-shop.net/samsung-laptop-battery-c-15.htmlhttp://www.batteries-shop.net/sony-laptop-battery-c-16.htmlhttp://www.batteries-shop.net/toshiba-laptop-battery-c-17.htmlhttp://www.uk-laptopbattery.com/acer-laptop-battery-c-2.htmlhttp://www.uk-laptopbattery.com/apple-laptop-battery-c-3.htmlhttp://www.uk-laptopbattery.com/asus-laptop-battery-c-4.htmlhttp://www.uk-laptopbattery.com/compaq-laptop-battery-c-5.html

  2. Unknown says:

    http://www.batteryfast.com.au/compaq/dv2000.htm Compaq dv2000 Battery http://www.batteryfast.com.au/compaq/dv2200.htm Compaq dv2200 Battery http://www.batteryfast.com.au/compaq/pavilion-dv2000.htm Compaq pavilion dv2000 Battery http://www.batteryfast.com.au/compaq/pavilion-dv6000.htm Compaq pavilion dv6000 Battery http://www.batteryfast.com.au/dell/d5318.htm Dell d5318 Battery http://www.batteryfast.com.au/dell/e1405.htm Dell e1405 Battery http://www.batteryfast.com.au/dell/gw240.htm Dell gw240 Battery http://www.batteryfast.com.au/dell/inspiron-630m.htm Dell inspiron 630m Battery http://www.batteryfast.com.au/dell/inspiron-640m.htm Dell inspiron 640m Battery http://www.batteryfast.com.au/dell/inspiron-8000.htm Dell inspiron 8000 Battery http://www.batteryfast.com.au/dell/inspiron-8100.htm Dell inspiron 8100 Battery http://www.batteryfast.com.au/dell/inspiron-8200.htm Dell inspiron 8200 Battery http://www.batteryfast.com.au/dell/m1210.htm Dell m1210 Battery http://www.batteryfast.com.au/dell/pu563.htm Dell pu563 Battery http://www.batteryfast.com.au/dell/rn873.htm Dell rn873 Battery http://www.batteryfast.com.au/dell/RU030.htm Dell RU030 Battery http://www.batteryfast.com.au/dell/td175.htm Dell td175 Battery http://www.batteryfast.com.au/dell/TK330.htm Dell TK330 Battery http://www.batteryfast.com.au/dell/w953g.htm Dell w953g Battery http://www.batteryfast.com.au/dell/WG317.htm Dell WG317 Battery http://www.batteryfast.com.au/gateway/m360.htm Gateway m360 Battery http://www.batteryfast.com.au/gateway/m460.htm Gateway m460 Battery http://www.batteryfast.com.au/gateway/m680.htm Gateway m680 Battery http://www.batteryfast.com.au/hp/dv9500.htm Hp dv9500 Battery http://www.batteryfast.com.au/hp/dv9600.htm Hp dv9600 Battery http://www.batteryfast.com.au/hp/dv9700.htm Hp dv9700 Battery http://www.batteryfast.com.au/gateway/8msb.htm Gateway 8msb Battery http://www.batteryfast.com.au/gateway/8msbg.htm Gateway 8msbg Battery http://www.batteryfast.com.au/hp/zt1000.htm Hp zt1000 Battery http://www.batteryfast.com.au/hp/zt3000.htm Hp zt3000 Battery http://www.batteryfast.com.au/ibm/02k6928.htm Ibm 02k6928 Battery http://www.batteryfast.com.au/ibm/02k7055.htm Ibm 02k7055 Battery http://www.batteryfast.com.au/ibm/02k7072.htm Ibm 02k7072 Battery http://www.batteryfast.com.au/ibm/thinkpad-r40.htm Ibm thinkpad r40 Battery http://www.batteryfast.com.au/ibm/thinkpad-t30.htm Ibm thinkpad t30 Battery http://www.batteryfast.com.au/laptop-ac-adapter/dell/inspiron-6400.htm Dell inspiron 6400 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/latitude-d620.htm Dell latitude d620 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/latitude-d630.htm Dell latitude d630 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/latitude-d820.htm Dell latitude d820 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/dell/d820.htm Dell d820 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/hp/dv4000.htm Hp dv4000 Adapter http://www.batteryfast.com.au/hp/pavilion-dv9700.htm HP pavilion dv9700 Battery http://www.batteryfast.com.au/hp/pavilion-dv9500.htm HP pavilion dv9500 Battery http://www.batteryfast.com.au/laptop-ac-adapter/liteon/presario-1200.htm Liteon presario 1200 Adapter http://www.batteryfast.com.au/laptop-ac-adapter/liteon/presario-1600.htm Liteon presario 1600 Adapter

  3. Unknown says:

    http://www.batterylaptoppower.com/compaq/presario-1200.htm Compaq presario 1200 Battery http://www.batterylaptoppower.com/compaq/presario-1600.htm Compaq presario 1600 Battery http://www.batterylaptoppower.com/compaq/presario-1800.htm Compaq presario 1800 Battery http://www.batterylaptoppower.com/dell/312-009.htm Dell 312-009 Battery http://www.batterylaptoppower.com/dell/4e369.htm Dell 4e369 Battery http://www.batterylaptoppower.com/dell/d5318.htm Dell d5318 Battery http://www.batterylaptoppower.com/dell/e1405.htm Dell e1405 Battery http://www.batterylaptoppower.com/dell/gw240.htm Dell gw240 Battery http://www.batterylaptoppower.com/dell/HG307.htm Dell HG307 Battery http://www.batterylaptoppower.com/dell/inspiron-1000.htm Dell inspiron 1000 Battery http://www.batterylaptoppower.com/dell/inspiron-1100-series.htm Dell inspiron 1100 series Battery http://www.batterylaptoppower.com/dell/inspiron-1150.htm Dell inspiron 1150 Battery http://www.batterylaptoppower.com/dell/inspiron-1200.htm Dell inspiron 1200 Battery http://www.batterylaptoppower.com/dell/inspiron-1300.htm Dell inspiron 1300 Battery http://www.batterylaptoppower.com/dell/inspiron-1521.htm Dell inspiron 1521 Battery http://www.batterylaptoppower.com/dell/inspiron-4000.htm Dell inspiron 4000 Battery http://www.batterylaptoppower.com/dell/inspiron-8000.htm Dell inspiron 8000 Battery http://www.batterylaptoppower.com/dell/inspiron-8100.htm Dell inspiron 8100 Battery http://www.batterylaptoppower.com/dell/inspiron-8200.htm Dell inspiron 8200 Battery http://www.batterylaptoppower.com/dell/inspiron-9300.htm Dell inspiron 9300 Battery http://www.batterylaptoppower.com/dell/inspiron-9400.htm Dell inspiron 9400 Battery http://www.batterylaptoppower.com/dell/inspiron-b120.htm Dell inspiron b120 Battery http://www.batterylaptoppower.com/hp/nc6000.htm Hp nc6000 Battery http://www.batterylaptoppower.com/hp/nc8000.htm Hp nc8000 Battery http://www.batterylaptoppower.com/hp/nx9500.htm Hp nx9500 Battery http://www.batterylaptoppower.com/hp/pavilion-dv8100.htm Hp pavilion dv8100 Battery http://www.batterylaptoppower.com/hp/pavilion-dv8200.htm Hp pavilion dv8200 Battery http://www.batterylaptoppower.com/dell/rn873.htm Dell rn873 Battery http://www.batterylaptoppower.com/dell/RU030.htm Dell RU030 Battery http://www.batterylaptoppower.com/dell/TK330.htm Dell TK330 Battery http://www.batterylaptoppower.com/dell/xps-m140.htm Dell xps m140 Battery http://www.batterylaptoppower.com/gateway/6500632.htm Gateway 6500632 Battery http://www.batterylaptoppower.com/hp/500.htm Hp 500 Battery http://www.batterylaptoppower.com/hp/520.htm Hp 520 Battery http://www.batterylaptoppower.com/mitac/bp-8050(p).htm Mitac bp-8050(p) Battery http://www.batterylaptoppower.com/mitac/bp-8089p.htm Mitac bp-8089p Battery http://www.batterylaptoppower.com/ibm/thinkpad-t42.htm Ibm thinkpad t42 Battery http://www.batterylaptoppower.com/ibm/thinkpad-t60.htm Ibm thinkpad t60 Battery http://www.batterylaptoppower.com/ibm/thinkpad-x41.htm Ibm thinkpad x41 Battery http://www.batterylaptoppower.com/ibm/thinkpad-z60m.htm Ibm thinkpad z60m Battery http://www.batterylaptoppower.com/ibm/thinkpad-z60t.htm Ibm thinkpad z60t Battery http://www.batterylaptoppower.com/ibm/thinkpad-z61e.htm Ibm thinkpad z61e Battery http://www.batterylaptoppower.com/ibm/thinkpad-z61m.htm Ibm thinkpad z61m Battery http://www.batterylaptoppower.com/ibm/thinkpad-z61t.htm Ibm thinkpad z61t Battery http://www.batterylaptoppower.com/mitac/8050.htm Mitac 8050 Battery

  4. Unknown says:

    http://www.batteryfast.com.au/acer/extensa-5210.htm Acer extensa 5210 battery http://www.batteryfast.com.au/acer/extensa-5220.htm Acer extensa 5220 battery http://www.batteryfast.com.au/acer/extensa-5620g.htm Acer extensa 5620g battery http://www.batteryfast.com.au/acer/travelmate-5710.htm Acer travelmate 5710 battery http://www.batteryfast.com.au/acer/travelmate-5720g.htm Acer travelmate 5720g battery http://www.batteryfast.com.au/acer/travelmate-7520g.htm Acer travelmate 7520g battery http://www.batteryfast.com.au/asus/a22-700.htm Asus a22-700 battery http://www.batteryfast.com.au/asus/a22-p701.htm Asus a22-p701 battery http://www.batteryfast.com.au/asus/eee-pc-1000.htm Asus eee pc 1000 battery http://www.batteryfast.com.au/asus/eee-pc-701.htm Asus eee pc 701 battery http://www.batteryfast.com.au/dell/latitude-d410.htm Dell latitude d410 battery http://www.batteryfast.com.au/dell/latitude-d420.htm Dell latitude d420 battery http://www.batteryfast.com.au/dell/latitude-d430.htm Dell latitude d430 battery http://www.batteryfast.com.au/dell/latitude-d610.htm Dell latitude d610 battery http://www.batteryfast.com.au/dell/latitude-d810.htm Dell latitude d810 battery http://www.batteryfast.com.au/dell/vostro-1310.htm Dell vostro 1310 battery http://www.batteryfast.com.au/dell/vostro-1320.htm Dell vostro 1320 battery http://www.batteryfast.com.au/dell/vostro-1510.htm Dell vostro 1510 battery http://www.batteryfast.com.au/dell/vostro-1520.htm Dell vostro 1520 battery http://www.batteryfast.com.au/dell/vostro-2510.htm Dell vostro 2510 battery http://www.batteryfast.com.au/hp/pavilion-dv2133.htm Hp pavilion dv2133 battery http://www.batteryfast.com.au/hp/pavilion-dv3000.htm Hp pavilion dv3000 battery http://www.batteryfast.com.au/hp/pavilion-dv3500.htm Hp pavilion dv3500 battery http://www.batteryfast.com.au/hp/pavilion-n5130.htm Hp pavilion n5130 battery http://www.batteryfast.com.au/hp/pavilion-n5150.htm Hp pavilion n5150 battery http://www.batteryfast.com.au/hp/pavilion-n5170.htm Hp pavilion n5170 battery http://www.batteryfast.com.au/ibm/thinkpad-X40.htm Ibm thinkpad X40 battery http://www.batteryfast.com.au/ibm/thinkpad-x41.htm Ibm thinkpad x41 battery http://www.batteryfast.com.au/ibm/thinkpad-x60.htm Ibm thinkpad x60 battery http://www.batteryfast.com.au/ibm/thinkpad-x60s.htm Ibm thinkpad x60s battery http://www.batteryfast.com.au/ibm/thinkpad-z60t.htm Ibm thinkpad z60t battery http://www.batteryfast.com.au/ibm/thinkpad-z61t.htm Ibm thinkpad z61t battery http://www.batteryfast.com.au/msi/bty-s11.htm Msi bty-s11 battery http://www.batteryfast.com.au/msi/bty-s12.htm Msi bty-s12 battery http://www.batteryfast.com.au/sony/vgp-bps5.htm Sony vgp-bps5 battery http://www.batteryfast.com.au/sony/vgp-bps5a.htm Sony vgp-bps5a battery http://www.batteryfast.com.au/toshiba/pa3178u-1brs.htm Toshiba pa3178u-1brs battery http://www.batteryfast.com.au/laptop-ac-adapter/hp/510.htm hp 510 adapter http://www.batteryfast.com.au/laptop-ac-adapter/hp/530.htm hp 530 adapter http://www.batteryfast.com.au/sony/vgp-bpl9.htm sony vgp-bpl9 battery http://www.batteryfast.com.au/sony/vgp-bps10.htm sony vgp-bps10 battery http://www.batteryfast.com.au/sony/vgp-bps8.htm sony vgp-bps8 battery http://www.batteryfast.com.au/sony/vgp-bps8a.htm sony vgp-bps8a battery http://www.batteryfast.com.au/sony/vgp-bps9.htm sony vgp-bps9 battery

  5. hfgh says:

    http://www.batteries-shop.nethttp://www.batterieslaptop.nethttp://www.uk-laptopbattery.comhttp://www.wt-batteries.comhttp://www.replicawatchesstore.nethttp://www.cheapteastore.comhttp://www.laptopbatterystore.co.ukhttp://www.batterieslaptop.nethttp://www.batteries-supply.comhttp://www.powertoolsbatteries.co.ukhttp://www.batterygrip.orghttp://www.uk-batteries.co.ukhttp://www.ukbatterystore.co.ukhttp://www.topbatteries.co.ukhttp://www.batteries-shop.net/acer-laptop-battery-c-2.htmlhttp://www.batteries-shop.net/apple-laptop-battery-c-3.htmlhttp://www.batteries-shop.net/asus-laptop-battery-c-4.htmlhttp://www.batteries-shop.net/compaq-laptop-battery-c-5.htmlhttp://www.batteries-shop.net/dell-laptop-battery-c-6.htmlhttp://www.batteries-shop.net/fujitsu-laptop-battery-c-7.htmlhttp://www.batteries-shop.net/gateway-laptop-battery-c-8.htmlhttp://www.batteries-shop.net/hp-laptop-battery-c-9.htmlhttp://www.batteries-shop.net/hp-compaq-laptop-battery-c-10.htmlhttp://www.batteries-shop.net/ibm-laptop-battery-c-11.htmlhttp://www.batteries-shop.net/lenovo-laptop-battery-c-12.htmlhttp://www.batteries-shop.net/lg-laptop-battery-c-13.htmlhttp://www.batteries-shop.net/panasonic-laptop-battery-c-14.htmlhttp://www.batteries-shop.net/samsung-laptop-battery-c-15.htmlhttp://www.batteries-shop.net/sony-laptop-battery-c-16.htmlhttp://www.batteries-shop.net/toshiba-laptop-battery-c-17.htmlhttp://www.uk-laptopbattery.com/acer-laptop-battery-c-2.htmlhttp://www.uk-laptopbattery.com/apple-laptop-battery-c-3.htmlhttp://www.uk-laptopbattery.com/asus-laptop-battery-c-4.htmlhttp://www.uk-laptopbattery.com/compaq-laptop-battery-c-5.htmlhttp://www.uk-laptopbattery.com/dell-laptop-battery-c-6.htmlhttp://www.uk-laptopbattery.com/fujitsu-laptop-battery-c-7.htmlhttp://www.uk-laptopbattery.com/gateway-laptop-battery-c-8.htmlhttp://www.uk-laptopbattery.com/hp-laptop-battery-c-9.htmlhttp://www.uk-laptopbattery.com/hp-compaq-laptop-battery-c-10.htmlhttp://www.uk-laptopbattery.com/ibm-laptop-battery-c-11.htmlhttp://www.uk-laptopbattery.com/lenovo-laptop-battery-c-12.htmlhttp://www.uk-laptopbattery.com/lg-laptop-battery-c-13.htmlhttp://www.uk-laptopbattery.com/panasonic-laptop-battery-c-14.htmlhttp://www.uk-laptopbattery.com/samsung-laptop-battery-c-15.htmlhttp://www.uk-laptopbattery.com/sony-laptop-battery-c-16.htmlhttp://www.uk-laptopbattery.com/toshiba-laptop-battery-c-17.htmlhttp://www.topbatteries.co.uk/acer-laptop-battery-c-1.htmlhttp://www.topbatteries.co.uk/hp-laptop-batteries-c-2.htmlhttp://www.topbatteries.co.uk/sony-laptop-battery-c-3.htmlhttp://www.topbatteries.co.uk/dell-laptop-battery-c-4.htmlhttp://www.topbatteries.co.uk/ibm-laptop-battery-c-5.htmlhttp://www.topbatteries.co.uk/compaq-laptop-battery-c-6.htmlhttp://www.topbatteries.co.uk/toshiba-laptop-battery-c-7.htmlhttp://www.topbatteries.co.uk/fujitsu-laptop-battery-c-8.htmlhttp://www.topbatteries.co.uk/apple-laptop-battery-c-9.htmlhttp://www.topbatteries.co.uk/samsung-laptop-battery-c-10.htmlhttp://www.cheapteastore.com/chinese-black-tea-c-3.htmlhttp://www.cheapteastore.com/chinese-herbal-tea-c-7.htmlhttp://www.cheapteastore.com/chinese-oolong-tea-c-2.htmlhttp://www.cheapteastore.com/chinese-puerh-tea-c-4.htmlhttp://www.cheapteastore.com/chinese-white-tea-c-5.htmlhttp://www.cheapteastore.com/chinese-yellow-tea-c-6.htmlhttp://www.cheapteastore.com/tie-guan-yin-c-8.html

  6. Sam Kane says:

    Here are this and some other articles on Parent-Child Dimension:

    http://ssas-wiki.com/w/Articles#Parent-Child_Dimension

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s