by ·Comments Off on Copy book from one application to other

Product:
Planning Analytics Workspace 2.1.14
Microsoft Windows 2022 server

Issue:

How do i easy copy one book in PAW to other TM1 instance?

Solution:

Copy the JSON code between the TM1 applications.

Go to the book, click on the Swedish keyboard CTRL+Q+’     (That is the * key left of the carriage-return key.)

This opens up the JSON code that describe the book. This can be copied to notepad for editing, or direct to other PAW book.

 

More Information:

https://www.acgi.com/blog/copying-tabs-across-books-in-ibm-planning-analytics-workspace

https://community.ibm.com/community/user/blogs/george-tonkin/2023/02/18/copying-a-tab-from-one-paw-book-to-another

https://www.ibm.com/docs/da/planning-analytics/2.0.0?topic=books-create-book

by ·Comments Off on Data source credentials

Product:

Power BI Dataflow

Issue:

After user account is changed (owner), the dataflow is not updated.  (this is only when you use a Power BI gateway to access SQL database on prem.)

 

Solution:

You have on the dataflow gone to settings, and change the owner to a other person. (by press the Take Over button)

On the dataflow tab go to EDIT

Click EDIT on one table.

You get a error message, that it can not contact SQL server.

Click on OPTIONS icon.

Click on project and data load, and change the data gateway to one in the dropdown list.

Click OK.

Now the table should be refreshed automatic, and you can save and close the dataflow.

 

More Information:

https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-configure-consume

https://learn.microsoft.com/en-us/power-query/dataflows/data-sources?tabs=power-bi-service

https://data-marc.com/2022/08/02/what-you-must-know-when-building-power-bi-dataflows-routing-over-the-on-premises-data-gateway/ 

by ·Comments Off on How unhide rows

Product:
Microsoft Excel 365
Planning Analytics TM1 perspective

Issue:

How unhide rows in excel?  I need to find the data for the formulas tm1rptview.

Solution:

To unhide rows in Excel is through the Ribbon:

  1. Open your spreadsheet in Excel.
  2. Click on the triangular Select All button in the upper left corner in your spreadsheet, or press CTRL + A.
  3. In the Home tab, go to the Format section > Hide & Unhide > Unhide Rows.

  • A row can look hidden if its height is set to zero, even if you didn’t hide it manually. So even if you right-click and choose Unhide, it won’t work in this case.

    Here’s how to fix this:

    1. Select the rows around the missing one.

    2. Go to Home > Format > Row Height (or right-click the row number and choose Row Height).

    3. Set the height to 15 (Excel’s default).

    4. Click OK, and the row should appear again.

  • If you have the Freeze Panes option on, try disabling it to see if the static state of panes is preventing the rows from completely showing up.
  • Filters can hide rows based on criteria, sometimes unintentionally. To remove filters:1)Go to the Data tab on the Ribbon.2) Click on “Filter” to toggle off any active filters, revealing any rows hidden by these filters.3) Removing filters can instantly bring back a significant portion of your “missing” data.

 

More Information:

https://xodo.com/blog/how-to-unhide-all-rows-in-excel 

https://www.xelplus.com/hide-unhide-excel/

https://www.simplesheets.co/blog/how-to-unhide-all-rows-in-excel

https://blog.octanesolutions.com.au/dynamizing-dynamic-reports-hacks

How to Create a List Report using a TM1 Dynamic Report

https://www.ibm.com/docs/sl/planning-analytics/2.0.0?topic=wf-tm1rptrow

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=functions-tm1rptview

 

TM1RPTVIEW defines the view displayed in a Dynamic Report.

Syntax

TM1RPTVIEW(ViewID,ZeroSuppression,TM1RPTTITLE,...)

Argument

Description
Required/Optional
ViewID A name for the view using the format server:cube:unique_id. Required
ZeroSuppression A Boolean flag to turn on or off the zero suppression property for the view. 1 = on, 0 = off Required
TM1RPTTITLE For each title dimension in the Dynamic Report, include a reference to a TM1RPTTITLE function as an argument to TM1RPTVIEW. Required
FormatRange The formatting range for the Dynamic Report. You can use a cell reference or a named range for this parameter.

When you create a Dynamic Report, a named range called TM1RPTFMTRNG is created to include all formatting range cells. You can use this named range as an argument.

 Required
IDColumn The column in the Dynamic Report that contains format IDs. You can use a cell reference or a named range for this parameter.

When you create a Dynamic Report, a named range called TM1RPTFMTIDCOL is created to include all formatting range cells. You can use this named range as an argument.

 Required

 

TM1RptRow sets the Active Form control row definition. The control row definition governs the behavior of all rows in the Active Form. This worksheet function is used to create Active Forms.

This worksheet function is valid in worksheets only.

Syntax

TM1RptRow(ReportView, Dimension, Subset, SubsetElements,
Alias, ExpandAbove,MDXStatement, Indentations, ConsolidationDrilling)

Argument

Description
ReportView A reference to a cell that contains a TM1RptView formula.
Dimension A dimension, specified using the format tm1_server_name:dimension_name.
Subset A named subset. If this argument is empty, all elements of the dimension will be used.
SubsetElements A cell range reference that specifies a list of elements to constitute a subset.

When this argument is supplied, the named subset specified by the Subset argument is ignored.

If this argument is empty, the elements from the subset specified by the Subset argument are used.
Alias A string that defines the alias used for the subset.

When this argument is supplied, it overrides the default alias property defined by the subset specified by the Subset argument.

If this argument is empty, the alias from the subset specified by the Subset argument are used.
ExpandAbove A Boolean flag to turn on or off the subset Expand Above property. When this argument is supplied, it overrides the default Expand Above property defined by the subset specified by the Subset argument.

If the argument value is 1, consolidated elements expand upward when drilling.

If the argument value is 0, consolidated elements expand downward when drilling.

If this argument is empty, the Expand Above property from the subset specified by the Subset argument is used.
MDXStatement An MDX statement that applies to the subset specified by the Subset argument.

When this argument is supplied, it overrides the default MDX filter defined by the subset specified by the Subset argument.

If this argument is empty or omitted, the elements from the subset specified by the Subset argument are used.
Indentations An integer value to indicate how many indentations are applied to each level when drilling down on a consolidated element. If the argument value is 0, no auto-indentation is performed.

This is an optional argument. When the value is missing, one indentation is applied to each level as you drill down on a consolidated element.
ConsolidationDrilling A Boolean flag to turn on or off drilling on consolidated elements.

When this argument value is 1, users can drill down on consolidated elements in the Active Form.

When this argument value is 0, users can not drill down on consolidated elements in the Active Form.

This is an optional argument. When the argument is missing, the default behavior is to allow drilling on consolidated elements.