Hello everyone
I get this error message every time I push button created by IBM PA.
Does anybody know how to solve this problem?
Thanks
Error 400 in PAx
-
TimeTq
- Posts: 9
- Joined: Mon Jan 20, 2020 9:06 am
- OLAP Product: TM1
- Version: 2.0.9.58
- Excel Version: 2019
Error 400 in PAx
- Attachments
-
- 400.png (5.4 KiB) Viewed 2621 times
-
gtonkin
- MVP
- Posts: 1261
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Error 400 in PAx
Got any protected sheets?
Possibly hidden sheets?
Wild guesses here.
Possibly hidden sheets?
Wild guesses here.
-
TimeTq
- Posts: 9
- Joined: Mon Jan 20, 2020 9:06 am
- OLAP Product: TM1
- Version: 2.0.9.58
- Excel Version: 2019
Re: Error 400 in PAx
I hadn't connect CognosOfficeTM1.xll and CognosOfficeBI.xll. After connection buttons TI Process start working.
But this error shows when i start this VBA code:
Public Sub ExecuteAction_4ded29e8_f7af_4b6e_bff8_787d58e98cd4()
'RebuildSpecification is used to return the MDX string that is used when rebuilding the Quick Report.
Range("I10") = Reporting.GetCurrentReport(Range("E9")).RebuildSpecification
End Sub
Public Sub ExecuteAction_132bb8bd_03bb_4a3d_abb5_409d57bfd329()
Dim a As String
a = Range("I10")
' ExecuteQuery is a method used to execute selected MDX statements in your Quick Report reports.
Range("M1:AA1") = Reporting.ExecuteQuery("...", "...", a)
' RebuildSpecification is used to return the MDX string that is used when rebuilding the Quick Report.
'Workbooks("TEST.xlsm").Sheets("List2").Range("F15") = Reporting.GetCurrentReport(ActiveCell).RebuildSpecification
End Sub
But this error shows when i start this VBA code:
Public Sub ExecuteAction_4ded29e8_f7af_4b6e_bff8_787d58e98cd4()
'RebuildSpecification is used to return the MDX string that is used when rebuilding the Quick Report.
Range("I10") = Reporting.GetCurrentReport(Range("E9")).RebuildSpecification
End Sub
Public Sub ExecuteAction_132bb8bd_03bb_4a3d_abb5_409d57bfd329()
Dim a As String
a = Range("I10")
' ExecuteQuery is a method used to execute selected MDX statements in your Quick Report reports.
Range("M1:AA1") = Reporting.ExecuteQuery("...", "...", a)
' RebuildSpecification is used to return the MDX string that is used when rebuilding the Quick Report.
'Workbooks("TEST.xlsm").Sheets("List2").Range("F15") = Reporting.GetCurrentReport(ActiveCell).RebuildSpecification
End Sub