Manohar Paleti

My photo
Hyderabad, AP, India
Working as a BI Consultant, Served for various organizations as an OBIEE Developer by building the BI Solutions for Business Decision Making..

Thursday, January 20, 2011

Interesting Requirement

Hi All,

Here is one requirement.
Fact                                                       Dimension1                     Dimension2
$ Net Amount                                         Year                                Product_name
$ Profit                                                    quarter                            Product_category
Status(Varchar(30)) (yer/no)                    Month                             Product_subcategory

Requirement :-

need do display ,
Year      Product_name      $Net Amount     Status(current)    Year_Ago_Status


appreciations for quick solution,

Thanks.

Posted by at

5 comments:

  1. chandanaJanuary 20, 2011 at 5:21 AM

    what is that yer/no???

    need clarification.

    ReplyDelete
  2. Manohar PaletiJanuary 20, 2011 at 5:43 AM

    Sorry its the Status (Yes or No)

    ReplyDelete
  3. Manohar PaletiJanuary 20, 2011 at 5:49 AM

    its the values of Status Column
    Yes
    No
    Yes
    No
    No
    ...

    ReplyDelete
  4. chandanaJanuary 20, 2011 at 7:53 AM

    do you want to show the same date i.e yes/no in year_ago_status also???

    ReplyDelete
  5. Manohar PaletiJanuary 20, 2011 at 11:24 PM

    Chandana,
    Prompt : Year
    Report--
    Year Amount Cur_year_status Prev_year_status

    Year is Prompted.
    here status is to analyze how well the business been flows in prev year to current year. status may like Fare, Good,Not Fare, Great....

    ReplyDelete

Subscribe to: Post Comments (Atom)