Smart View
Discussion List
-
connect to essbase via webversion of excelSummary: connect to essbase via web based excel office 365 I have installed the chrome addin for smartview, opened excel 365 in chrome, i dont see smartview add in to co… -
How to avoid the parameters in the BIP report output which is a .cvs file?I am creating a BIP report. Expected output is in .csv format. I tried both RTF and the direct report builder, but still in the output I am getting the parameters as the…
-
View Exchange Rate in SmartviewBusiness user would like to view the PeriodEnd exchange rate in smartview. So that the user could able to see what rate has applied when they review the balance of that …
-
Smartview Essbase Error [1020098]: Duplicate name found in Grid, unable to resolve.Summary: I get the following Smartview error in report that used to work fine, adjusting the Account dimension values fails to resolve the issue, Essbase Error [1020098]… -
How to run MDX query with multiple Select statementsSummary: I'm running an MDX query that times out with the following error message: I'm trying to circumvent this limitation by breaking down the query into two smaller o…
-
Error trying to run MDX query via VBASummary: I'm trying to run MDX query using HypExecuteMDXEx function. Just took a sample from the book, put in my parameters and a database, and when I tried to run it, g…
-
Smartview retrieve file gets very large on saveSummary: Hello, We have one user, when he Smart View retrieves on 5 different template files, the retrieve works fine, but when he saves, the Excel file will grow to a v…
-
Recording SmartView report's "Last Retrieved" timeSummary: I have a SmartView report (Version 23.200). The report has about 50 data pull sheets and one control sheet where I define parameters (such as Product and Entity…
-
Is possible to use Smartview in Android?Hi All, Does anyone knows if there is a way to use SmartView in an Android smartphone? I really appreciate any help Regards,
-
How can I use HypUIConnect without a friendly name?Summary: I need to convert multiple Smart View reports to point to a different database. The "from" and "to" database have different number of dimensions; some dimension…
-
Smartview error: "Member **** is out of place" when refreshing ad-hoc formsWhen selecting Member name and alias in "Options", display them simultaneously. After improvising the form and refreshing it, it will prompt: Member **** is out of place…
-
Error using summation in MDX querySummary: I'm trying to pull data from Essbase using a group of members that I need to sum up. To do it, I'm using WITH statement that looks something like that: With Mem…
-
Dynamic filters errorSummary: Hi we are experiencing error with dynamic filters in Essbase MP 21.4.3 when submiting data using Smart View. Content (required): Error message: Error(1200315), … -
Will Smartview connect to SnowflakeSummary: We are implementing Snowflake currently and will Smartview add-in connect to Snowflake as a datasource? I don't think so but thought I would get the conversatio… -
Essbase Substitution Variable not working after migrationSummary Essbase Substitution Variable not working after migrationContent Hi Experts - Greetings!! I am migrating older Essbase version to a newer version (11.1.2.2 to 11… -
Office 365 and Smart ViewContent I read that smart view is only working in desk version of microsoft office applications. But now Microsoft is trying to push customers towards Office 365. What i… -
Smartview settings - Member name and AliasSummary Set report to show both member name and Alias but disappears when someone else refreshContent Hi, I am using smart view version 11.1.2.5.910 (build 172). Even si…
-
Smart View Options - no longer saved on a report?Content Hi I am currently using v910 of smart view and previously I was using v710. When I was using v710, I remember that I can set different smart view options in each…User_2025-01-22-19-46-04-749 28 views 3 comments 0 points Most recent by User_2025-01-22-19-46-04-749 Essbase
-
Cube Designer ErrorSummary When building BSO cube in Cube Designer - fails with "Member name already exists"Content I have a complex BSO cube (many complex formulas, large sparse dimension… -
Smart View add-ins querySummary Hyperion Smart View - HsTbar.xla Excel add-in, HsAddin.dll COM add-in differencesContent Hi All, Some of our users are facing issue with existing macro enabled w…User_2025-03-07-21-45-06-805 19 views 1 comment 0 points Most recent by Karthikeyan Pasupathy-89036 Essbase
-
Smartview with Microsoft TeamsSummary Will Excel Workbooks work in Microsoft TeamsContent Hi Community, We'd like to know if Microsoft Excel Workbooks that use Smartview will work when used through M… -
Essbase and Google SheetSummary Seeking FeedbackContent Hi, Has anyone tried using google sheets to access essbase and built smart view report? Please share experience. Regards, Jenny
-
HypSetSSO VBA FunctionSummary Has anyone passed SSO credentials to automate connections in ExcelContent I'm familiar with how to connect on-prem and hosted solutions where login credentials a…
-
PJTD in Smart ViewSummary Select PJTD as AMOUNT TYPEContent Hello All New to Oracle Fusion and the Smart View world. Quick question is it possible to select PJTD (Project to date) as the …
-
Smart View Error message "The data entered is wrong, so it will revert to the previous value"Summary The data entered is wrong, so it will revert to the previous valueContent I have created a smart view file that has a lot of columns. There formula involved that…
-
Essbase connection on Smart View change to newSummary Is there a quick way to update SV connection on existing Essbase retrieve files?Content We upgraded the Hyperion applications and users need to change to new con…User_2025-01-31-16-14-51-428 30 views 2 comments 0 points Most recent by User_2025-01-31-16-14-51-428 Essbase
-
SmartView Backwards Compatible with older version of ExcelSummary Is SmartView 11.1.2.5 900 compatible with older version of ExcelContent Hello Essbase World, I have a question about SmartView and Excel when connecting to Essba…
-
OAC Essbase Google Sheets add-onSummary You can now access your OAC data from Google Sheets exactly like you do in Excel using Smart View.Content We're happy to announce the availability of our "OAC Es…User_2025-02-04-20-31-44-581 86 views 2 comments 0 points Most recent by User_2025-02-04-20-31-44-581 Essbase
-
Formula to retrieve the top ancestor for an entity memberSummary Trying to run a report that identifies the parent or top ancestor for all entity membersContent Trying to run a report that identifies the parent or top ancestor…
-
Method to find intersection with actual data in Essbase with SmartViewSummary I'm trying to find a simple way of targeting an intersection where there is non-missing, non-zero data.Content Hello Oracle Essbase World, I have a fairly simple…