Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM installation

1042469Oct 21 2013 — edited Oct 22 2013

Hi,

I am totally new at Hyperion and FDM.

I have installed Hyperion Planning on Linux base system, now i want to install FDM.

I have installed FDM on Windows server 2008 (another server) but now when i am trying to configure it; its giving me registry error.

I think i might have missed prerequisites for FDM installation.

I have only installed Foundation services and FDM on Windows Server 2008. Do i have to install any thing else? essbase client? RDBMS client? Any thing else?

I am looking at documentation to but its taking time.

Thanks in advance.


Regards.

This post has been answered by 1042469 on Oct 22 2013
Jump to Answer

Comments

graeme-06501

That's interesting, I have a page with a master grid and detail grid and thought I'd check as this doesn't sound good.

When I navigate to a different master without saving the detail it doesn't ask me to save, is that a setting somewhere?  I can try it if you remind me how to set that up?

I can go to a different master record, create a detail record for it and not save, going back to my original master record the unsaved detail record correct for that master is still there.

When I save both detail records are saved to the correct master, it never asks me to save.

Does the detail grid have a column which is nominated as having a master column and that master column is definitely unique?

Not sure if it makes any difference, I'm using 20.1 and for processing my master grid is set to automatic row processing and the detail is set to PL/SQL

Andreas Wildmann

I had some progress since yesterday. Apparently, while the two grids followed a Master Detal structure, it wasn't set up as that. Now it is. The Interactive grid on the right side has the left grid as being the Master Detail, while it also has one of it's keys marked as a Master Column.

Saving it does work as well, but with a quirk. When I add new information into a row, then change it to another row, I still get the "You haven't saved" mesage. When I cancel, it still changes to the row that I just clicked, and if I save, it does save it to the previous row, not the current one. So far so good.

However, the information i saved isn't being shown. I checked the database and the saved information has been stored in the table, but it isn't being shown on the grid. At first I thought it had simply refreshed, and I rather needed to load the page again, but it still doesn't show the data. Kinda curious if this is a glitch or I'm making a mistake when it comes to understanding how these Master Detail Grids are set up.

Andreas Wildmann

Just another update, the data is now being shown in accord to the Master Column. Becaus there were a couple of unintuitive primary keys in that query, I mistook one of them. But as usual, there is another problem:

This the sequence of the issue:

1. When first selecting a row in the Master Detal, I can see the data on the Child Grid properly.

2. When then selecting another row in the Master Detail, the data from the currently selected row loads properly in the Child Grid.

3. Now I click again on the row from before in the Master Detail, and the Child Grid is empty.

Considering that the Child Grid depends on the Master Column, I don't think it is an issue regarding the assynchronous loading of that column.

Doing a quick debug also brings me some random results. At times, I get nothing but the foreign key inside the table (with the Grid also being empty) while at times I do get something in the console.log command, but the Grid is empty.

Andreas Wildmann
Answer

Feels like I'm flooding my own topic while also seeming like I'm talking to a mirror.

I solved the issue somewhat by accident. I suspected it could've been that but only now tested it properly.

I had a "where foreign_key = :FK" condition in the Child Grid, while also having the Foreign Key in it be the Master Column, and I imagine that was causing a conflict.

Now everything is working properly, the records aren't being saved in the wrong row,and the data in the Child Grid is being shown.

Marked as Answer by Andreas Wildmann · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details