Importing Metadata in Smart View

10-11  Source: Network gathering  Views:3 

Advertisement
Dear All,
In Smart view when I migrate the metadata from one worksheet to other its is not getting migrated. I have followed the below steps still its not..
To import metadata to a copied worksheet :
1. Back up your work.
2. From the Smart View menu, select Options, then Advanced, and ensure that Improved Metadata Storage is
selected.
3. Use Excel to copy a worksheet. This operation copies the visible contents of the source worksheet but not the
metadata (connection information, POV selections, alias tables and the like) to the destination worksheet.
4. With the destination worksheet active, from the Smart View menu, select More, then Import Metadata to
display a list of all open workbooks and their corresponding open worksheets.
5. From the list, select the worksheet that contains the metadata that you want to import to the destination
worksheet.
6. Click OK. You will be asked to confirm your selection.
7. Refresh.
Help in solving this issue is highly appreciated.
Thanks,
Kamal
I don't know what back end you are connecting to, but when I follow the steps you outlined with Essbase's Good Old Sample.Basic, it works just fine -- the members that were selected in the POV are migrated across.
This is on Excel 2007 with Essbase 11.1.2.0.
Regards,
Cameron Lackpour
Related articles
  • Importing Metadata in Smart View 10-11

    Dear All, In Smart view when I migrate the metadata from one worksheet to other its is not getting migrated. I have followed the below steps still its not.. To import metadata to a copied worksheet : 1. Back up your work. 2. From the Smart View menu,

  • Importing FR into Smart View 11.1.2.1 11-30

    When I open smart view and connect to FR, try to open an FR doc, I get the respond to prompt then an Essbase Error(1051085): You do not have sufficient access to get this substitution variable.] Any ideas what this means?It means that you for some re

  • Getting error while importing metadata using View Objects 10-11

    Hi All, I am trying to create a repository using View Object in OBIEE 11.1.5.1 but getting error while viewing the data, after importing the metadata in the repository "[nQSError: 77031] Error occurs while calling remote service ADFService11G. Detail

  • I'm currently using Adobe Acrobat X to create PDF portfolios for client deliverables. Within the portfolio, there is a "Files" view which can be seen below. I'm interested in knowing if it's possible to bulk import metadata into either the Description fie 10-11

    I'm currently using Adobe Acrobat X to create PDF portfolios for client deliverables. Within the portfolio, there is a "Files" view which can be seen below. I'm interested in knowing if it's possible to bulk import metadata into either the Descr

  • Financial Reports import into excel using Smart View - error 10-11

    All, I have encountered an error message when trying to use R&A Import. The message is Oracle Hyperion Smart View for Office, Fusion Edition "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns

  • Issue importing interactive reporting into excel smart view 9.3 10-11

    I am new to smart view, and while importing an interactive document from a system9 portal in excel, it always returns "Error Accessing Import Data", after clicking finish in the wizard, even though i was able to preview the document in the previ

  • Smart View internal metadata error when creating SmartView reports 11-30

    Hi all, I have a really strange problem when trying to use HsGetValue -functions in Smart View (in Excel 2010). The thing is that I can create a lot of formulas for a sheet that have links to other sheets. However, in some pont (I don't exactly when

  • Changing the language of imported metadata in Indesign 10-11

    Hello, I hope someone can help me with my issue... I am running InDesign CS5 Middle Eastern edition on a Mac and would like to import metadata from bridge - the issue is: when I import the info, which includes numbers, it uses Arabic intead of Englis

  • Oracle Smart View 11.1.2.5.400 prompt bug still not resolved? 10-11

    Good morning, in our company we have OBIEE 11.1.1.7.140715 and we are testing Oracle Smart View 11.1.2.5.400 (Build 376) on Excel 2007 32 bit and Excel 2013 64 bit to allow our final users to work more easily. Unfortunately almost all of our reports

  • Access Issue Smart View 10-11

    Hi all, Few user in our company are having hard time opening Data forms in Smart View. When they try to open the forms they get an following Error: The data Form XXXX Is invalid.Check Log for details. (where XXXX is the name of form). I have tried fo

  • Import Metadata Wizard not loaded 10-11

    Hi, I'm new to  Oracle Warehouse Builder, I want to load data from a flat file (source file) but Import Metadata Wizard not loaded after creation of flat file module or nor launch Import Metadata Wizard manually. It shows me the screen as in the link

  • Smart View freezes excel 11-30

    I have a specific excel sheet which, when opened in excel with active Smart View add-in, always freezes up. Disabling the add-in allows to open the sheet but as soon as the add-in is reactivated it freezes again. Windows 7, Excel 2010, Smart View 11.

  • What does #Invalid mean in Smart View 11-30

    Some users get a #invalid result in their Smart View queries. It only seems to display when there is no data (i.e. #missing), and we are curious as to why it doesn't just display as #missing. What parameters cause Smart View to classify something as

  • Import Metadata - connection failed 11-30

    Hi All, When I try to do "import metadata" by right clicking on my database I get connection failed error. In this the datasource name and user name are defined repository variables. Whereas, if I do "import metadata" from under the fi

  • Import metadata error. 11-30

    Hi, everyone. I have a task. I need to develop ADF Business Component using only WEB-services and integrate this app into BI Repository. So, I developed this app, and completed all steps here -> [http://docs.oracle.com/cd/E15586_01/fusionapps.1111/e2

  • Can't load data through smart view (ad hoc analysis) 10-11

    Hi, There is EPM application where I want to give ability to planners to load data through smart view (ad hoc analysis). In Shared Services there are four options in EssbaseCluster-1: Administrator, Create/Delete Application, Server Access, Provision

  • Smart View error logging in to an application 10-11

    Hello, I successfully installed Smart View on a computer with Windows XP SP3. I can connect to the data source, but when I try to connect to an application, after entering the username and password, an error pops up: "Requested operation failed. Erro

  • Not able to export web analysis report to excel smart view from workspace 10-11

    Not able to export web analysis report to excel smart view from workspace. Error :Web launch operation has been cancelled. Can anyone help me to resolve this issuesI realized that I can put a block in WebI and then I can pull that in excel alongside

  • Issue with smart view add-in in MS word 2003 10-11

    Hi, I have smart view 9314 and office 2003 installed on my machine. I can see hyperion tab in excel and it works fine but i can't see hyperion tab in word or powerpoint. Its not in disabled items for word. I tried to add HsTBar.xla in word using Temp

  • Excel 2007 and Smart View 9.3.1.4.041 10-11

    Dear Experts, We are now working with Excel 2007 and Smart View 9.3.1.4.041, and encounter the problem that ervery time open the protected excel file there would be the warning message "Drawing Objectes in one or more sheet(s) in the workbook are pro