Hey There,<BR><BR>Anybody know how to produce a row dim pull using cross dim "->" or equivalent.<BR><BR>I need to put together a Rep Scripts that pulls some Measure Dim members intersected with certaind Deps "Operationals", and other Measure Dim member intersected with a different Depts "Non-Operational" just like this<BR><BR><ROW(Measures, Dept)<BR><BR>Revenue Ops Dep<BR>Cost Ops Dep<BR>Revenue Non-Ops<BR>Cost Non-Ops<BR><BR>the <LINK command does not work because it works with members of the same dimension. I tried:<BR><BR>Revenue -> Ops Dep<BR>Cost -> Ops Dep<BR>Revenue -> Non-Ops<BR>Cost -> Non-Ops<BR><BR>but this only generates the first combination.<BR><BR>Any ideas?<BR><BR>Osvaldo<BR><img src="i/expressions/wine.gif" border="0">
I tried this before but unfortunatelly that generates 4 combinations (all possible combinations), not the specifics ones I'm looking for (described above). W/ more dim I need to add to the row section there will a lot of extra lines that I will have to eliminate afterwards.<BR>Any other suggestions? Actually I'm not sure if this is possible to do.<BR>Thanks for help anyway !
<p>There may be a better way, but you could put more than onereport script into the single report, if that makes sense. I've stacked them on top of one another all in one script andhad it work out. That way, each of your "reports"within the report would have just one of the member combinations,and generate one line each. Not elegant, but it shouldwork.</p>
Yes, that will accomplish the overall cross dim goal.<BR><BR>Actually Jade's tip will do the task. (See below)<BR><BR>"Then you need to put a bang (!) after each row:<BR><BR>dim1Mbr1 dim2Mbr1 !<BR>dim2Mbr2 dim2Mbr2 !<BR>etc<BR><BR>Regards,<BR>Jade<BR>----------------------------------<BR>Jade Cole<BR>Senior BI Consultant<BR>Clarity Systems<BR>email@example.com<BR>www.claritysystems.com "