Can we flatten a key figure structure in BEx 7.0 like in BEx 3.5?

[Former Member]

Hi,

Our company has recently forced the upgrade to our users of BEx 3.5 to BEx 7

We have key figure structures, that display like hierarchies in BEx Analyzer 7.0.

In BEx 3.5, through the yellow pencil\local query editing, you could undo the key figure "hierarchy", essentially flatten.

But in BEx 7.0, I cannot seem to find that functionality through the "...Query Properties"?

It is important to our end-users to have this flexibility of having the hierarchy and removing it within BEx Analyzer.

I am hoping we do not need to have two queries, that BEx Analyzer 7.0 can do something that 3.5 could.

Does anyone know how this is possible?

[Former Member]

Looking into this more...

I think the only way to give back the end-users the ability for the Local Query View is to adjust BI authorizations.

Authorizations for BI Reporting by Prakash Darji

Using the XYZ queries concept.

Allow power users ability to make their own temporary queries, or save to their Favorites.

Not as simple (admin free) as during the BEx 3.5 era, but I guess the price of progress.

_____

ANPC

[Former Member]

Hi,

You can achieve the scenario mentioned in pic1 in Bex 7.0 but not sure about scenario 2.

Please check below image for Bex 7.0 properties. You can select default mode in parent KF display

properties.

Thanks,

Reshma M.

[Former Member]

Hi Anshu,

Yes, that is what was possible in BEx 3.5 within the functionality of BEx Analyzer, using "local version" of query.  So whatever you changed would only be stored in the workbook of that user, not everyone else. 

From what I see in 7.0, you can only do the drag and drop of a structure within Query Designer and it would change the query stored on BW server and impact all other users.

In our BW Production system, we do not allow our end-users to edit a query. 
From what I can tell so far, the Query Designer will not let you edit a localized version of query (am I mistaken?).

If I want to do what Reshma shows and what Anshu were saying about dragging and dropping nodes to make a key figure "hierarchy", then we need to go into Query Designer where the person would have authorizations to edit the global\server version of query....

or maybe our BW BASIS people have forgotten to enable something for BEx 70 so that we can use Query Designer to edit query without impacting the query stored on the BW server?

In your own environments, can you use query designer in a way that it only impacts your version of the query within your own saved workbook?   We do not want to allow users to make changes to the query/workbook saved in the "Role" on the BW server.

We want to give users ability to switch from scenario 1 and scenario 2 easily without making changes to the server version of the query.

Also I notice that for Structures, we can't go to Properties within BEx Analyzer 70, it is greyed out, is this normal?

thanks everyone for the help

[anshu_lilhori]

Hi,

Check the below thread:It talks about workaround to have that feature in 7.0.Hope it suffice your requirement.

http://scn.sap.com/message/4844545

Regards,

AL

[Former Member]

Thanks Anshu.

Though reading the two threads, I get the impression the author's question was never answered, just assumed answered.

I tried the workaround mentioned, but I might be dim, I don't see how the workaround works... I tried checking off the two properties mentioned in the Data Provider, nothing changed in my ability to change the structure of the key figure...

Does it change for anyone else? That checking off "result offline" and "restore intial query" does anything to allow changing the query?

Maybe it does and I need to configure something in the BW system?

But the question itself goes a long the same line.

We do not want to give our users global authorization to change Queries, but we want them to have ability to change the structure of the query, like they could in BEx 3.5 with "Local Query".

It seems to hint that a "Query View" can help... but I have yet to figure out how.

I will try to search the forums for BEx 7.0 and local query version.

Edit:

After reading the linked threads more carefully, I would say that the Author realized there is Right-Click and ...Query Properties

And I would say 80% of the functionality of the "Yellow Pencil" in BEx 3.5 can be done in Query Properties, however there is still this 20% that I have not been able to figure out and our end-users actually use.

I found that If you convert to Formulas, it does flatten the structure, but you can't switch back and unconvert from BEx Formulas... seems like a one-way trip.

Message was edited by: Alan Cheun

[tnecnivo]

Hi Alan,

Although I am not familiar with 3.X ver BEx, but I have worked on 7.X ver BEx for quite sometime now.

Can you provide screenshot on the Key figure structure you are talking about?

e.g. 1. How the Current Key figure Hierarchy structure, and how you want it to be.

Kind regards

[Former Member]

Thanks Vincent for the interest.

I took a small screenshot of what the end-user wants to be able to see and remove as needed.

In BEx 3.5, you could have this Key Figure Structure that looks like a Hierarchy in the query and when you went to "Edit Local Query" ~Query Designer for local version of query only, you could drag and drop the inner nodes of structure out, so it would be like the bottom picture.

In BEx 7.0, I do not see or have not found the "Query Designer" for local version of query to edit in Production within BEx Analyzer (no developement/server version of query editing required).

[tnecnivo]

From the look of your screenshot, have you tried de-activate the hierarchy in BEx Designer?

Open BEx query

> Open your query

> click on Rows/Columns

> then Click/Select to highlight the Characteristic/Key figure

> On your right side of the screen, there should be a properties section

> Click on Hierarchy Tab

> Un-Tick on (Activate Hierarchy Display).

Try and see whether it works.

Edited:-

After looking at what Anshu said, it suddenly make sense to me now, he is correct, just drag and drop will do, make sure you drag the child node to the same level of the parent node if you want it do display in flat mode.

Message was edited by: Vincent Ong

[anshu_lilhori]

Hi,

I am not much familiar with 3.5 Bex but in case you need to display hierarchy for keyfigures then in query designer you have to manually do that.

By dragginng and dropping the object as required which indeed creating parent child relationship

Hope that helps.

Regards,

AL