List of Contributions

If your report is a DYNAMIC report (rows drill up and down), then from PAx (PAfe), do a search for TM1RPTROW and TM1RPTVIEW. The View statement is usually hidden towards the top of the sheet. The RptRow statement is the first row/left column of your data results. If you want to upload your report I can ...

In this example: The Client element is: 123456/John And, we know that we will always have 7 characters before the NAME begins. You could use the following to get "John": SUBST ( Client , 8 , LONG ( Client ) – 7 ) ) If your prefix length varies you may need to use a variation of ...

You must create the alias first before you can load names to it. You can do this within the same TI process in the Prolog. ------------------------------ Arden Miller ------------------------------

You can create an Alias on the )Clients dimension to store just the person's name. Then in the )ClientsGroups cube view you can turn that alias on in the )Clients dimension. If you don't have the "name" as a stand alone field to load in from your data source you can use the SUBST function, possibly ...

Register for our Webinar: QueBIT has released a FREE replacement for the much sought after Print Reports capability that has been missing in Planning Analytics for Excel. The feature, which is built on top of QueBIT's ReportWORQ, is similar to the Perspectives version and is 100% free to all ...

Hoping this is resolved by now. But for additional reference on PAW security, please see our knowledge base article: https://quebit.com/askquebit/IBM/planning-analytics-workspace-security/ ------------------------------ Arden Miller ------------------------------