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!

Load YTD figures from PBCS BSO cube to HFM via FDMEE

IGMSep 20 2019 — edited Oct 11 2019

Hi,

I need to create an integration in FDMEE to copy data from a BSO cube (periodic data) in pBCS to HFM (YTD). The data needs to be extracted from PBCS as YTD. And this is the thing that I am struggling with. I have tried referencing dynamic time series in FDM but this turned out to be too slow.

Can someone suggest a better solution?

Kind regards,

Comments

ryan sullivan2
You could always use javascript to update the title.

-ryan
929656
Sure. Is there a way I can get section name in java script?
stellentpmp
Just do this in the page template:
<title><!--$wcmFragment("wcm", "[fragment content ID]", "[fragment ID]", "[snippet]")--></title>

And then just update the fragment to reflect what you want.

Alternatively, switch to Design mode and click on the placeholder (ie. region1). Then in the "Properties" window, update the "Title" property to what you want. You can also put idoc in there.

To get the section label in idoc, use <!--$sectionLabel = ssGetNodeLabel(siteId,nodeId)-->

Hope this helps.
929656
Sure that provided an important clue. Here is what I did:

1) Tools -> Define Custom Section Properties, I added a new property "SectionNodeId".
2) For each of my section I configured this value to be equal to SectionId
3) I then went to the common page (that acts as a primary page in multiple sections) and clicked on a placeholder. That showed up "Title" property in the Properties window.
4) I put this "<!--$ssGetNodeLabel("<Hardcoded site id>",ssGetNodeProperty("SectionNodeId"))-->" in the Title.

It worked. Thanks for your help.
ryan sullivan2
Nice job!
1 - 5