Skip to Content

Dummy Entires in report output

Hi All,

I have report (Age analysis)which created on multiprovider.

when i execute (Age Analysis) report it will display selection screen as below.

production year/month. == Jan 2001 to May 2001

class == A

in my cube there is data for only Jan,Feb, April, May and there is no data for MARCH. Now i want show data for MAR/2001 with all keyfigures 0(Zero) values.

Can anyone suggest some solutions.

Prod Y/M Key figure1 Key figure2

Jan-2001 23 232

Feb-2001 23 232

Mar-2001 0 0

Apr-2001 23 2323

May-2001 23 232

by

CCC

Edited by: CCC on Jul 30, 2008 2:36 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2008 at 09:02 AM

    Are you getting blank in the key fig value for march.

    If so,create a cal key fig > put inside >original key fig + 0.

    anl also check in the query properties >rows/columns >uncheck the suppress zero option.

    Cheers,

    Shana

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 03:59 PM

    In Query designer >go to the query >select the time char, go to advanced tab, under the acces type for result values, check the master data option.

    Add a comment
    10|10000 characters needed characters exceeded

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.