1 2 Previous Next 21 Replies Latest reply on Nov 20, 2010 5:25 AM by Rupesh Shelar

    Hours in Page Prompt

    Rupesh Shelar
      Hi Gurus,,

      my question is to Mr.Kishore,Sandip,Saichand specifically

      Can i get some solution for hour based dashoboard\page prompt in the report level

      thanks
        • 1. Re: Hours in Page Prompt
          SaichandVaranasi
          hi,
          hour(time_column) is that u want ?

          what do u mean by page prompt in report level?

          you mean to say ....dashboard having hours prompt based on the value in prompt the report should filter? is that what u r asking?

          thanks,
          Saichand.v
          • 2. Re: Hours in Page Prompt
            Rupesh Shelar
            Hi Gurus,

            Yes, exactly

            Thanks
            • 3. Re: Hours in Page Prompt
              SaichandVaranasi
              hmmm...then create the prompt with fx hour(date_column_name) use the same fx formula in report ,Is Prompted on that column on report


              Thanks,
              Saichand.v
              • 4. Re: Hours in Page Prompt
                Rupesh Shelar
                Hi,

                this is the sample data if we click on hour-21 and date is 17 then and conditon is grater than equal to then it is not showing the data of 20th where hour value is 21 PM

                COLUMN1 COLUMN2 Hour
                1.0 8/17/2010 10:21:14 PM 22
                2.0 8/18/2010 10:21:14 PM 22
                3.0 8/19/2010 11:21:14 PM 23
                4.0 8/20/2010 9:21:14 PM 21

                it is tested for so many times.need solution

                thanks

                Edited by: user1124854 on Nov 18, 2010 1:42 AM
                • 5. Re: Hours in Page Prompt
                  SandeepSaini
                  Can you provide link to your old thread.

                  Regards,
                  Sandeep
                  • 6. Re: Hours in Page Prompt
                    Rupesh Shelar
                    Hi Gurus,

                    which thread you wants timestamp,hour level

                    thanks
                    • 7. Re: Hours in Page Prompt
                      SandeepSaini
                      I think you have opened another thread in which you were having difficulties extracting date and timestamp.That thread.May be someone else had opened it.Please check if you can provide that link so that we can understand your problem better.

                      Regards,
                      Sandeep
                      • 8. Re: Hours in Page Prompt
                        Rupesh Shelar
                        Hi Gurus,

                        There is nothing to understand here, hour exract from timestamp or from some other table it is not fetching correct records when it is added to timestmp from the report

                        thanks
                        • 9. Re: Hours in Page Prompt
                          SandeepSaini
                          i hope you are getting hour from prompt and in your report you want all the rows where hour>Value from prompt.If that is the case declare a presentation variable in prompt lets say pv_hour.

                          And in report put a filter on hour columns as hor_column>@{pv_hour}.

                          Please elaborate setsp you took to create the report and prompt.

                          Regards,
                          Sandeep
                          • 10. Re: Hours in Page Prompt
                            Rupesh Shelar
                            Hi Gurus,

                            when i am trying to add pv_hour in hour filter getting below mentioned error message


                            Error Details
                                 
                            Error getting drill information: SELECT TABLE2.COLUMN3 saw_0, TABLE2.COLUMN2 saw_1 FROM yy WHERE (TABLE2.COLUMN3 > pv_hour)
                            State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "pv_hour". (HY000)


                            syntax is
                            COLUMN3 is greater than @{ pv_hour}

                            thanks

                            Edited by: user1124854 on Nov 18, 2010 7:54 AM
                            • 11. Re: Hours in Page Prompt
                              SandeepSaini
                              Declare presentation variable in prompt.You are not explaining what you are doing.Explain us step by step what you are doing ...

                              Regards,
                              Sandeep
                              • 12. Re: Hours in Page Prompt
                                Rupesh Shelar
                                Hi Gurus,


                                Delclared presentation variable in the prompt set variable=pv_hour

                                while declaring the variable in filter of hour column(column3)-
                                syntax is
                                click on hour(column3) + filter + select greater than condition and add variable + pres. variable + enterd pv_hour

                                COLUMN3 is greater than @{ pv_hour}

                                and i got below mentioned error details

                                Error Details
                                Error getting drill information: SELECT TABLE2.COLUMN3 saw_0, TABLE2.COLUMN2 saw_1 FROM yy WHERE (TABLE2.COLUMN3 > pv_hour)
                                State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "pv_hour". (HY000)

                                hope you understand

                                thanks
                                • 13. Re: Hours in Page Prompt
                                  SandeepSaini
                                  hi,

                                  give some default value there for presentation variable,This error is coming because you have not given any default value for PV_HOUR.Give default vale and report wont error out.when you select anything from prompt,this variable will be overwritten by that value.

                                  In your filter you have to give a default value.

                                  Regards,
                                  Sandeep
                                  • 14. Re: Hours in Page Prompt
                                    Rupesh Shelar
                                    i enterd below mentioned things in date and Hr(hour filter
                                    click folter + assign greater than equal to + given default

                                    DATE11 is greater than or equal to @{pv_time}{17-AUG-10}
                                    AND HR is greater than or equal to @{pv_hour}{10PM}


                                    when i clicked on 18-aug date and 10am time, it says no results
                                    No Results
                                    The specified criteria didn't result in any data. This is often caused by applying filters that are too restrictive or that contain incorrect values. Please check your Request Filters and try again. The filters currently being applied are shown below.


                                    DATE11 is equal to 18-AUG-10
                                    and HR is equal to 10AM

                                    DATE11 HR
                                    17-AUG-10 10PM
                                    18-AUG-10 10PM
                                    19-AUG-10 01PM
                                    19-AUG-10 05PM
                                    19-AUG-10 10AM
                                    20-AUG-10 21PM

                                    this is sample data .pls help if you really have a solution

                                    thanks

                                    Edited by: user1124854 on Nov 19, 2010 4:16 AM
                                    1 2 Previous Next