Skip to Content

BEx : Day wise report

Hi Experts ,

I have a requirement for the report, where for the current week it should display the respective week and then day wise.

I have created a variable where it is taking the current week but i need to know how i can make that report display day wise.

Kindly help,

Thanks in advance ,


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2009 at 06:47 AM


    I think you can just add Calendar day in your query. As you have alredy filtered the contents to current week, the report will therefore only display days that are within that week.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member M S

      Hi M.S.,

      Unfortunately you will not be able to generate any Characteristic values in the Report/Queries which is not present in the Cube/DSO etc directly.

      But you can achieve this through "Virtual Characteristics". But performance wise, it might be little slower.

      Pls go through the below link.

      I would suggest you to add the 0CALDAY, 0CALMONTH, 0CALYEAR & 0CALWEEK to your infocube and do a Time Conversion. It is the best way. Fortunately you dont have to delete the data, you can make use of the "Remodelling" option available in the BI7.x version.

      Pls award points, if helpful.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.