12 Replies Latest reply on Jun 22, 2014 9:58 PM by Sagar Kapoor

Text of dimension from SAP BW

Julia Nguyen Mar 18, 2014 6:30 AM

Hi,

I need some help from people using Tableau with SAP BW. I'm using SAP BEx Query as a datasource in Tableau and I can't show the description text of the dimension but only the keys. I tried everything in Tableau and can't change what is shown.

I've found this idea, I don't know if it will work and I'm looking for something easier...

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/405c695a-4c43-2e10-3c81-90ab1470e7e1?overridelayout=t…

Thank you.

1. Re: Text of dimension from SAP BW

Ashok Veluru Mar 20, 2014 2:42 AM (in response to Julia Nguyen)

Hi Julia,

Even I am facing the same problem. Please let me know if you got the fix for this issue.

Also, I have gone though the document attached, and its a lengthy process.
Like Show 0 Likes(0)

Actions
2. Re: Text of dimension from SAP BW

Ashok Veluru Mar 20, 2014 3:07 AM (in response to Julia Nguyen)
Hi Julia,

Looks like I found the setting to enable the Text and Key in Tableau.

Right click on the Dimension --- > Aliases --- > Select the type of display.

Please find the snpahsot attached for reference

Displaying Text Description_Connect Bex Query.jpg 98.5 KB

4 of 4 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: Text of dimension from SAP BW

Julia Nguyen Mar 20, 2014 3:13 AM (in response to Ashok Veluru)

Hi Ashok,
I was clicking on the wrong dimension that's why I didn't find this Aliases menu. What a relief, thank you so much
Like Show 0 Likes(0)

Actions
4. Re: Text of dimension from SAP BW

Ashok Veluru Mar 20, 2014 3:15 AM (in response to Julia Nguyen)

Welcome
Like Show 0 Likes(0)

Actions
5. Re: Text of dimension from SAP BW

Julia Nguyen Mar 20, 2014 3:18 AM (in response to Ashok Veluru)

It's hard to find people working with BW and Tableau. May I have your e-mail or skype to share our experiences?
Like Show 0 Likes(0)

Actions
6. Re: Text of dimension from SAP BW

Ashok Veluru Mar 20, 2014 3:57 AM (in response to Julia Nguyen)

Sure.. Pls reachout to me @ ashokveluri@gmail.com
Like Show 1 Likes(1)

Actions
7. Re: Text of dimension from SAP BW

Valeriy Churkov Jun 11, 2014 5:34 AM (in response to Julia Nguyen)

Hi, Julia ! Did you have a project, based on Tableau + SAP BW ? It's very interesting, as i plan to implement first such a project in Russia. It would be very interesting to ask you some questions about problems and limitations of such a configuration.
Like Show 0 Likes(0)

Actions
8. Re: Text of dimension from SAP BW

Julia Nguyen Jun 11, 2014 5:55 AM (in response to Valeriy Churkov)

Hi Valeriy !
Yes I'm still working with SAP BW and Tableau. If you are not working with SAP BW extracts you will have tons of problems and limitations and it will take hours to do a simple thing.
If you have extracts here is the list of limitations :
http://kb.tableausoftware.com/articles/knowledgebase/sapbw-extract-limitations
No need to say, that these issues are not a big deal at all!

If you need more information you can send me an e-mail
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
9. Re: Text of dimension from SAP BW

Valeriy Churkov Jun 11, 2014 7:32 AM (in response to Julia Nguyen)

Thanks a lot !) We haven't bought licenses yet.

If we talk about extracts, i think we need a server with lots of memory (RAM) for saving and supporting extract. ?

"Incremental extracts are not supported." - this means, that if i extract all my BW data, i cant add further data into it ?
"User hierarchies" - i wont be able to create my own hierarchies for drill-down ? ... Only hierarchies from BW ?
Can i use data as data type, or just as usual dimension ?
What about performance of an extract ? ...

What about entire feel of SAP BW + Tableau ? Do you feel, that integration is too raw ?

Did you try mobile ?

What about your project, was it finished, successfull ?

Could you, please, include the most complex dashboard, based on BW extract ?

Thanks in advance =)
Like Show 0 Likes(0)

Actions
10. Re: Text of dimension from SAP BW

Valeriy Churkov Jun 11, 2014 7:37 AM (in response to Ashok Veluru)

Ashok, hi !

What can you tell about questions above ?

Thank you !
Like Show 0 Likes(0)

Actions
11. Re: Text of dimension from SAP BW

Julia Nguyen Jun 11, 2014 8:16 AM (in response to Valeriy Churkov)

That's a lot of questions there!
I think it's better to create a new topic about SAP BW connectivity. It will give a better visiblity of this topic which deserves to be mentioned more often.
Then I'll answer your question with pleasure!
Like Show 0 Likes(0)

Actions
12. Re: Text of dimension from SAP BW

Sagar Kapoor Jun 22, 2014 9:58 PM (in response to Julia Nguyen)

Hi Julia,
Need you help I am working on how to make a summarized report in Tableau using BEx query of the same which is being made by using BO.The problem I am facing is that I want to re-structure my dimensions by creating calculated figures but when I am going to create a calculated figure only measure it is showing.

Thanks & regards,
Sagar Kapoor
Like Show 0 Likes(0)

Actions