This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
HI, I am browsing the cube from excel. I pulled few attributes into filters. in another tab, I got all attributes listed. my requirement is, Capture all filter values from first tab and fill it in second tab. for ex. in the first pic, I browsed cube and used 4 columns in filter and selected some values. I want to see those values in the second tab for respective attributes.
Could you please share more detailed information?
In order to help you better, I need to confirm some information with you:
1.How do we confirm the content of the attribute?
For example, after filtering in Figure 1, the data in Figure 2 is directly extracted from SQL based on these conditions?
2.What kind of connection did you create to import data from SQL to Excel?
3.If possible, I hope you can share some screenshots of the source data.
Looking forward to receiving your reply.
Hi, I am using below connection type to connect to SSAS cube from excel. and so far, I got first tab which is connected to cube and browse data. and second tab with all possible attributes in cube. Now, i need to connect both. so that when user pull xyz column to filter and select a value, it should appear under xyz column in tab 2.
Hi @Prajwal Potula
I am checking to see how things are going there on this issue.
If there's anything you'd like to know, don't hesitate to ask.
You can solve it in MS Excel by linking in sheet 2 the cells from sheet 1.
Can you please provide more details on this or point me to any example /link online?
That just a simple Excel function.
Enter an equal = sign in a cell and then click on an other sheet/cell to link it; formula will look like
=Sheet2!A1