GetURLsForCell

Retrieves all URLs whose regions cover a specified POV.

Syntax

<HsvData>.GetURLsForCell bstrScenario, bstrYear, bstrPeriod, bstrEntity, bstrAccount, pvarabstrURLNames, pvarabstrURLs

Argument	Description
bstrScenario	String (ByVal). The Scenario dimension.
bstrYear	String (ByVal). The Year dimension.
bstrPeriod	String (ByVal). The Period dimension.
bstrEntity	String (ByVal). The Entity dimension.
bstrAccount	String (ByVal). The Account dimension.
pvarabstrURLNames	Variant array. Array of URL names.
pvarabstrURLs	Variant array. Array of XML blocks representing URL links and their multi-language display names.

Example

The POV should contain exactly one element in each dimension. The function will not support MEMBERALL or member lists. This function will perform a cache lookup on the region cache for all URL names and URLs matching this POV. The following example will return a list of all URL names and XML blocks for URL for the given POV scenario “Actual,” year “2008,” period “January,” entity “Stamford,” and account “Sales.”

GetURLsForCell (_T(“Actual”), _T(“2008”), _T(“January”), _T(“Stamford”),_T(“Sales”), pvarabstrURLNames, pvarabstrURLs);

An example of the returned BSTR array pvarabstrURLNames would contain “ERPI_SalesReport” and “ERPI_EUSalesReport.” An example of the returned BSTR array pvarabstrURLs would contain two BSTR. The first BSTR looks like the following:

<foldercontents path="/">
  <resource name="Sales Report" description="" type="application/x-hyperion-applicationbuilder-report">
    <attribute name=”name” type=”string” xml:lang="fr" value=”Rapport de ventes” />
    <attribute name=”name” type=”string” xml:lang="es" value=”Informe de ventas” />
    <action name="Display Drill-Back" description="Launch Drill-Back" shortdesc="drill-back">
      <url>./HyperionFDM/AuthorizedPages/IntersectionSummaryByLocation.aspx?&amp;fdmAppName=CommaFDM&amp;fdmTargetAppName=Comma95&amp;sso_token=$SSO_TOKEN$&amp;sso_username=$SSO_USERNAME$&amp;sso_password=$SSO_PASSWORD$&amp;$ATTR(id)$&amp;RCP_VERSION=$RCP_VERSION$</url>
    </action>
  </resource>
</foldercontents>

The second BSTR looks like the following:

<foldercontents path="/">
  <resource name="EU Sales Report" description="" type="application/x-hyperion-applicationbuilder-report">
    <attribute name=”name” type=”string” xml:lang="fr" value=”EU Rapport de ventes” />
    <attribute name=”name” type=”string” xml:lang="es" value=”EU Informe de ventas” />
    <action name="Display Drill-Back" description="Launch Drill-Back" shortdesc="drill-back">
      <url>./HyperionFDM/AuthorizedPages/IntersectionSummaryByLocation.aspx?&amp;fdmAppName=CommaFDM&amp;fdmTargetAppName=Comma95&amp;sso_token=$SSO_TOKEN$&amp;sso_username=$SSO_USERNAME$&amp;sso_password=$SSO_PASSWORD$&amp;$ATTR(id)$&amp;RCP_VERSION=$RCP_VERSION$</url>
    </action>
  </resource>
</foldercontents>