In a previous post, I achieved success regarding Asset Class and Portfolio. I now realize, that the results are not quite what I need.
Using the following:
Queries:
Query 1 [Asset Query] contains [Reporting Asset], [Manager Group Code], [Major Issue Group]
Query 2 [Main Query] contains [Reporting Asset], [Manager Group Code], [Major Issue Group], [Portfolio #], [Market Value] , and other dimension and measures.
Merged Dimensions:
[Reporting Asset]
[Manager Group Code]
[Major Issue Group]
Extend Merged Dimensions is activated
Variables:
[v_Investment Segment Code]
Qualification: Detail
Associated Dimension:[Main Query].[Manager Group Code]
Formula: =[Inv Segment Code]
[v_Asset Class]
Qualification: Dimension
=If([Asset Class].[Reporting Asset]=“Synth”
And [Manager Group Code]=“PUB”;“Synth”
;If([Asset Class].[Major Issue Group]=“Lending”;“Lending”
;If([Asset Class].[Manager Group Code]=“CSH”;“Cash”
;If([Asset Class].[Manager Group Code]=“EQT”;“Stock”
;If([Asset Class].[Manager Group Code]=“MTG”;“Mortgage”
;“Other”)))))
Report Columns:
[v_Investment Segment Code]___[v_Asset Class]MainQuery].[Market Value][Etc.]
The result is:
2120__Synth____$50
2120__Lending___ 20
2120__Mortgage__35
2130__Stock_____60
_Cash—
In other words, because Cash has no detail records in either [v_Investment Sgement Code], I only see a summary line for it. Additionally, if the Asset Class does not exist for the [v_Investment Segment Code], nothing appears. I need to see all Asset Classes for each [v_Investment Segment Code]. What I’d like is:
2120__Synth____$50
2120__Lending___—
2120__Cash_____—
2120__Stock_____—
2120__Mortgage__35
2130__Synth_____—
2130__Lending___20
2130__Cash_____----
2130__Stock_____60
2130__Mortgage__—
If this is impossible, tell me to go fly a kite. thanks
LaurenBOXI 
(BOB member since 2009-09-15)