creating a workbook with seven queries- a question??

[Former Member]

Hi All,

I am trying to create a workbook out of seven queries. I am also trying to keep the title and free characteristics in the Workbook and be able to refresh with new filter values. But when I am running the query I am not seeing the free charateristics in the analyzer after running it. I think it can be done using the design mode function but need help which function to use. In a nutshell..

1) I want this WB to have free characteristics after running the query along with title and embed six other queries into the same WB.

How could this be done??

Thanks for ur help.

-Akash

[Former Member · Accepted solution]

Hi Akash,

Try using Insert navigation pane design item in each of your workbooks sheets, for the corresponding queries.

Click on a cell where you want to place your free characteristics.

Go to BEx Design toolbar.

Click on insert navigation pane.

Doble click on the cell , to define the properties of this navigation pane.

Go to dimensions tab. Move the characteristics you want as free characteristics from available dimension to selected dimensions.

Go to diplay tab, and allow all display check boxes

To go back to report display, you can click on the (icon A in the design BEx toolbar), to switch off the design mode.

Hope this is how you wanted it!

Best regards,

Sunmit.

[Former Member]

Apologies, accidentally had posted twice.