PAx switch model/package name in exploration view

[TomaszB]

Hi,

Does someone know if there is a way to switch the "model name"/"package" in PAx in an exploration view by connecting it to a named range?
If I try to do it like in a dynamic/custom report, then the formula in the system information cell gets overwritten by PAx.
I need it to switch between the dev and prod models.

BTW: The way described in the documentation (link below) is not working -> Bug already raised to development.
But even if this would work, it isn't something that can be used in a productive environment where I would like to create multiple views.
It's a NO-GO to edit each view and change it manually...

https://www.ibm.com/support/knowledgece ... e_pkg.html

The only usable solution I have found so far was the recreation of the exploration on each sheet by using a script.
Reporting.Explorations.Create "http://10.138.208.118/", "Some_Model", "Cube", "View"

Do you have some better experience with this kind of report?

Best Regards
Tomasz

[gtonkin]

Apologies if I am missing something but looks like you can unhide the hidden rows for the exploration and point the value next to System: to a named range which references your Server:Instance e.g. Denil:Denil_Development

[TomaszB]

Hi gtonkin,

That's exactly the point. When I edit the system information cell (by default C3), then PAx is resetting my change each time the sheet gets refreshed.
I'm using PAx 2.0.50. Is this working differently for you?

Best Regards
Tomasz

[Mithun.Mistry1103]

Hello

Any answers on this.

I have tried to use name ranges to connect explorations and quick reports through the one string, changing through environments via this one string.

Only problem is it connects to the existing rather than new connection when I refresh book.


Thank you

[gtonkin]

One answer is "maybe"...

Open your template and then have a look at the custom properties on the sheet (not workbook)

Try this code:

Code: Select all

Sub ShowCustomProperties()
    Dim oCustom As Variant
    Dim wsSheet As Variant
    
    For Each wsSheet In ActiveWorkbook.Sheets
        For Each oCustom In wsSheet.CustomProperties
            Debug.Print wsSheet.Name & " - " & oCustom.Name & vbCrLf & oCustom.Value & vbCrLf & vbCrLf
        Next
    Next
End Sub

The connection is possibly in the property "COR_PackageSearchPath": { "server" : "My Server", "cube" : "Exchange Rate"}

In terms of linking this property to a named range directly, doubt that will work but you could possibly update the value of the property.

All this is speculation but let us know if you solve with the above.

[Steve Rowe]

This is pretty hidden, had to raise a ticket to discover myself. Instructions here
https://www.ibm.com/docs/en/planning-an ... xploration

[gtonkin]

This is pretty hidden, had to raise a ticket to discover myself. Instructions here
https://www.ibm.com/docs/en/planning-an ... xploration

Thanks for that post Steve - far safer than hacking the custom properties!