Hi,
This is the error that me and and some of my friends faced while connecting to Essbase from Financial Reporting Studio, while creating grid... Logging into FR studio is working fine that means HSS is up and running but while creating a report in FR when we drag a grid and try to connect to some essbase server it is throwing an Error: " Can't connect to server" so, new server connection is not getting established. Here is the solution :
1. Check if you can connect to any other Essbase server from Studio. If yes, then check if you are using correct login credentials to connect to essbase. Also, try to connect to that essbase server using your login credentials from Excel Add-in or SmartView or AAS.
2. Check if all BI+ Services are up and running on Server.
3. Stop and Start BI+ services in the following order:
1. BI+ Core Services
2. Workspace
3. Financial Reporting Java RMI
4. Financial Reporting Print Server
5. Financial Reporting Report Server
6. Financial Reporting Scheduler Server
7. Financial Reporting Web Server
5. If still problem exists, run config utility for BI+, and re-configure Database with Drop all tables option.
Cheerz!
-CJ
Showing posts with label Hyperion Financial Reporting. Show all posts
Showing posts with label Hyperion Financial Reporting. Show all posts
Thursday, July 16, 2009
Sunday, January 11, 2009
Display Planning supporting details in FR
Showing Supporting Detail for Planning
When using the Planning Details database connection, and selecting a row, you can display
supporting detail for a member. If supporting detail exists for one or more cells in the selected
row, additional rows are inserted to show the supporting detail. In addition, you can control
whether a page break is allowed within the rows of supporting detail.
➤ To show supporting detail for the Planning Details database connection:
1 Open a report and select a row in the grid that contains a member with supporting detail.
2 In the Row Properties sheet, select Display Supporting Details.
3 Specify whether to allow page breaks with the rows of supporting detail:
● To allow a page break within the rows of supporting detail, select the Allow Page Break
Within check box.
● To keep the parent member and the supporting detail on the same page, deselect the Allow
Page Break Within check box. If the supporting detail does not fit on the current page, the
parent member and supporting detail is moved to the next page.
Note:
If the supporting detail spans multiple pages, this option defaults to Allow Page Break
Within and page breaks are used.
4 Optional: To position the supporting detail before or after the parent member, select the Grid Properties
sheet, select the Position category and select an option in the Position of Supporting Detail box:
● To display supporting detail before the parent member, click Before Members.
● To display supporting detail after the parent member, click After Members. This is the
default.
5 Optional: To indent each generation within the supporting detail:
a. Select the heading cell of the member that is going to display the supporting detail.
b. Select Format > Cells > Alignment tab.
c. In the Indent Increases for Each Generation by box, select a positive number by which
you want to indent (to the right) each generation in the supporting detail list, or select a
negative number to indent in reverse (to the left) each generation in the supporting detail
list.
When using the Planning Details database connection, and selecting a row, you can display
supporting detail for a member. If supporting detail exists for one or more cells in the selected
row, additional rows are inserted to show the supporting detail. In addition, you can control
whether a page break is allowed within the rows of supporting detail.
➤ To show supporting detail for the Planning Details database connection:
1 Open a report and select a row in the grid that contains a member with supporting detail.
2 In the Row Properties sheet, select Display Supporting Details.
3 Specify whether to allow page breaks with the rows of supporting detail:
● To allow a page break within the rows of supporting detail, select the Allow Page Break
Within check box.
● To keep the parent member and the supporting detail on the same page, deselect the Allow
Page Break Within check box. If the supporting detail does not fit on the current page, the
parent member and supporting detail is moved to the next page.
Note:
If the supporting detail spans multiple pages, this option defaults to Allow Page Break
Within and page breaks are used.
4 Optional: To position the supporting detail before or after the parent member, select the Grid Properties
sheet, select the Position category and select an option in the Position of Supporting Detail box:
● To display supporting detail before the parent member, click Before Members.
● To display supporting detail after the parent member, click After Members. This is the
default.
5 Optional: To indent each generation within the supporting detail:
a. Select the heading cell of the member that is going to display the supporting detail.
b. Select Format > Cells > Alignment tab.
c. In the Indent Increases for Each Generation by box, select a positive number by which
you want to indent (to the right) each generation in the supporting detail list, or select a
negative number to indent in reverse (to the left) each generation in the supporting detail
list.
Subscribe to:
Posts (Atom)