cancel
Showing results for 
Search instead for 
Did you mean: 

Show values in all rows

Former Member
0 Kudos

Hi All,

I want to use Excel sheet coming out from a report as a output, so for below case i am not able to find solution.

My data is as below.

Country    Char 1    Key-Figure1

India         A             10

                               20

                B             30

                               40

But i want to see output as below

Country    Char 1    Key-Figure1

India         A             10

India         A             20

India         B             30

India         B             40

Is there any option available in BEx?

Regards,

Ganesh

Accepted Solutions (1)

Accepted Solutions (1)

former_member182470
Active Contributor
0 Kudos

Do not use Suppress repeated Key Values option in the Query. I am doubtful...

The above advice may not work in your case bcoz, your excel itself does not contain repeated values. IS it possible to make the changes in Excel before loading to BW?

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello Experts,

I am facing the same problem..

Tried unchecking 'Hide Repeated Key values' under Display tab in Query properties.

But no luck..

Could you please suggest

Regards,

Shreeja

0 Kudos

Hi Ganesh,

Yes this can be achievable in BEx.Go to Query properties --> 'Display' tab --> uncheck ' Hide repeated key values' option. This satisfies your requirement.

Thanks,

Shreya J

Former Member
0 Kudos

Hi Shreya,

I can see this is not working, in web when i select setting for table > Data Specific Setting > Display Repeated Text. It is working... This seems to be WAD template setting.

Now when i get it in Advance Analysis still it is same. Does any way to make it default so that template specific properties will not come in between.

This will help me to bring this data in same format in BO tools.

Regards,

Ganesh

Former Member
0 Kudos

Hi All,

Thanks for your inputs. I got a option in Advance Analysis to repeat values in Datasource setting at Components tab.

Thanks for helping me out.

Regards,

Ganesh

Former Member
0 Kudos

hey Ganesh, I have the same problem, can you please explain where you found the solution

Former Member
0 Kudos

Hello Experts,

I am facing the same problem..

Tried unchecking 'Hide Repeated Key values' under Display tab in Query properties.

But no luck..

Could you please suggest

Regards,
Shreeja

Former Member
0 Kudos

Hi Ganesh,

As suggested by Suman, Unchecking 'Hide repeated key values' for your characteristic variable in display tab should solve your problem.

Br,

H

Former Member
0 Kudos

Hi Suman, Harish and Anshu,

Thanks for reply, but this option is not working even when i just run query in analyzer, Advance Analysis, in EP Portal. Not sure, is there any other things present in those tool.

Regards,

Ganesh

anshu_lilhori
Active Contributor
0 Kudos

Hi,

Follow the link:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/403986c0-8c84-2e10-17a6-88b5af5c6...

Refer the page no 17 of the above PDF

Hope that helps.

Regards,

AL