P&L Report Design Issue

[Ali Mostafa]

Hi Everyone,

I need to create a calculated filed for  example Commercial Margin = Sales + Retail Discount + Other Income , I have tried to use Selection Steps option analysis . The issue of step option that , I can't sort calculated filed .




Group Account Dim



Report Structure



Have anyone has any idea?


Regards,
Ali

[Murali Abburu]

Ali,

On the table analysis properties select "outside the hierarchy"  for placement of members. 

Then select the members in the order you want. Then ,

You can embed the calculated member in whatever order you want

Reg

Kris 

Sent from my iPhone

On May 22, 2017, at 3:05 AM, Ali Mostafa <a.most...@gmail.com> wrote:

Hi Everyone,

I need to create a calculated filed for  example Commercial Margin = Sales + Retail Discount + Other Income , I have tried to use Selection Steps option analysis . The issue of step option that , I can't sort calculated filed .

<Auto Generated Inline Image 1>



Group Account Dim
<Auto Generated Inline Image 2>


Report Structure
<Auto Generated Inline Image 3>

Have anyone has any idea?


Regards,
Ali

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

<Auto Generated Inline Image 1>

<Auto Generated Inline Image 2>

<Auto Generated Inline Image 3>

[Ali Mostafa]

Dear Kris,

Many thanks ,  it's working  great !!.

Do you have any idea how can make drill-down for "Selection Steps" calculated filed ?

Regards,
Ali Mostafa

obiee-enterprise-methodology+unsub...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Murali Abburu]

Ali

You should use conditional formatting on the metric to make it to work..

Thanks

Kris

Sent from my iPhone

obiee-enterprise-met...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.

[Ali Mostafa]

Dear Kris ,

I have used conditional formatting as below screenshot , but still shows an error . Could you please guide me?

Filter Error

Regards,

Ali Mostafa

obiee-enterprise-methodology+unsubs...@googlegroups.com

For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsubs...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

<Auto Generated Inline Image 1>

<Auto Generated Inline Image 2>

<Auto Generated Inline Image 3>

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to

obiee-enterprise-methodology@googlegroups.com

To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsub...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to

obiee-enterprise-methodology@googlegroups.com

To unsubscribe from this group, send email to
obiee-enterprise-methodology+unsub...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---

You received this message because you are subscribed to a topic in the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/obiee-enterprise-methodology/Dd0S0WH6jDo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to obiee-enterprise-methodology+unsub...@googlegroups.com.