How unhide rows – CogKnowHow

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:

Open your spreadsheet in Excel.
Click on the triangular Select All button in the upper left corner in your spreadsheet, or press CTRL + A.
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.