5 Replies Latest reply: Aug 8, 2007 3:31 PM by 3004 RSS

    Cross Dim in Rep Scripts

    3004
      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">
        • 1. Cross Dim in Rep Scripts
          3004
          <p>You could just put one line each all accounts and departmentsthat you want.</p><p>Revenue</p><p>Cost</p><p>Ops Dep</p><p>Non-Ops</p><p> </p><p>That should generate all combinations I believe.</p>
          • 2. Cross Dim in Rep Scripts
            3004
            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 !
            • 3. Cross Dim in Rep Scripts
              3004
              <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>
              • 4. Cross Dim in Rep Scripts
                3004
                Try the <ASYMMETRIC spec. It should print only the specific row dimension combinations you specify.
                • 5. Cross Dim in Rep Scripts
                  3004
                  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>jcole@claritysystems.com<BR>www.claritysystems.com "