use a detail variable as another query’s dimension

[whyirene]

I created a detail variable, with a merged key from two queries, how to use that detail variable as a dimension to a third query? I cannot find a joint value from these three queries to be a key.

[moshenaveh]

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

[vishalakshmi]

Hello Wang,

you can achieve this by creating a derived table or a universe that combines the data from the three queries.

• You've already created a detail variable by merging keys from two queries. Make sure this detail variable is defined correctly and contains the merged key values you need.
• To use the detail variable as a dimension in a third query, you'll typically need to create a derived table or universe that combines the data from all three queries. A derived table is a table you create within the BusinessObjects universe specifically for reporting purposes.
• In your derived table or universe, you need to map the detail variable to the appropriate columns from the original queries. This mapping tells the BI platform how to retrieve data for this variable.
• In the derived table or universe, define the necessary joins or relationships between the data sources. This is where you link the data from your merged key (detail variable) to the relevant data in the third query. Although you mentioned that there might not be a direct key, you'll need to establish some logical relationship based on available data.
• Now that you have a derived table or universe with the detail variable and the necessary joins, you can create your third query using the data from this source. In this query, you should be able to use the detail variable as a dimension.
• Design your report or analysis using the third query, and include the detail variable as a dimension in your report.

Thanks,

Lakshmi.