Re: Data Display in dashboards based on Yearly, Monthly, weekly wise

[Naresh Chintala]

Hi All,

Recently I got a requirement on one report. Functionality of the report is.. .i.e. to display total tickets worked by a individual person over time & grouped by day. So, here business requirement is this: they want to see Yearly, Monthly and Weekly options in the Prompt.Suppose when we select Yearly the trends should show for all 12 Months and if you select Monthly we should show the weekly wise trends in that Month as well as  when we select Weekly option it should display trends for all 7 days.

Could you please let me know how to achieve.

[Rebecca Widom]

I was curious to see this post, so I don't exactly have an answer, but I wanted to see what others in the group have to say.

It seems to me that this is kind of the point of drill downs, right?  So, if you have a date range as the prompt -- i.e. start date and end date -- and then show yearly by default, and then can drill to monthly, weekly, or daily depending on what they want to see?

Is the issue that your users don't want to drill down?  Or is it that they want to use yearly, monthly and weekly to set the date range?  Like, choose current year, current month, current week or something that you could calculate based on system variables?

Thanks.

Rebecca

[Gianni Ceresa]

Can't you just change the period column of your report conditionally? Using a formula with CASE WHEN to select the correct level (month, week, day) based on the prompt? You also add a condition based on the granularity you selected in the prompt to limit to the last 12 months (yearly), last 4 weeks (monthly) or last 7 days (weekly).

[Gómez Rodríguez Nilley]

Hi Naresh,

I thin that in OBIEE exists some way that implement your requariment. I let you two options:

1. If is posible implement in one answer the report with differents views and use a selector view for select the option to show Yearly, Monthly or Weekly view.

2. If the first option is not posible and you have 3 reports, one for eache option, then you can designe a page Dashboard wiht a three sections and each section should has active a visibilite condition over a prompt and the prompt has the three options.  This option is the worse choice due poor performance because all selects of the three reports will be executed always, although it shows only one.

Regards.

Nilley

--
--
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/groups/opt_out.

[Joel Acha]

I agree Gianni. It should be a case of creating a dashboard prompt that populates a variable and using the variables value in CASE statements for time level (yearly, monthly or weekly) in the column and same CASE statement logic in filter to determine period (yearly, monthly or weekly)

Regards

Joel

Sent from my iPhone

--

--
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.

[Vijayaraghavan R]

I totally agree with Rebecca. This is the best example of a drill down report. We as consultants should suggest the best and cleanest solution to the customer.

If the customer is persistent, then the solution given by Gianni is the best one. We could use variables in the prompts and then use them in the report.

Vijay