Smart View
Discussion List
-
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…
-
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…
-
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…
-
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…
-
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…
-
Working Day MetricSummary Analyzing various statistics against working daysContent We recently implemented two OAC Essbase cubes, 1 ASO and 1 BSO. Within the BSO cube, our dense dimension…
-
Planning Analyze not workingSummary Planning Analyze not working - " Ad hoc grid can not be opened as there are no valid rows of data"Content Hello, After the May update we noticed an odd behavior … -
Capture Data in Unlocked Cell in Protected Workbook Smart View ErrorSummary Capture Data in Unlocked Cell in Protected Workbook Smart View ErrorContent Hi I've created an ad-hoc grid to enable users to load data into an OAC Essbase cube.…