TM1 Forum

I normally copy the ReturnViewHandle below the generated section then go to the data source and set to none.

I generally only need the parameters so that I can build and assign the view in Prolog. No need for Metadata and data. YMMV

I normally start an active form by identifying what drives the results. In your case, you need to decide which measures drive it i.e. show the row if one-sided is non-zero, show if two-sided is non-zero etc. Based on the screenshot, the activeform will show a row if any of the columns has a non-zero...

Thanks for the information - unfortunately in my case it did not appear to be something else on port 80 but will definitely add your comments to my ever-growing notes for the next time!

... StrToMember(" [Site].[ "+[}ElementAttributes_Project].([}ElementAttributes_Project].[Primary Site])+"]") StrToMember as you said wants a string - the reference to Primary Site is still an element/member. Try adding a .name to the end i.e. StrToMember("[b][Site].[[/b]"+[}ElementAttributes_Projec...

A fairly quick low-tech way may be to use the command prompt and Excel: Open the command prompt, cd to your TM1 data folder then do: DIR *. /b >directories.txt - open the resulting txt file in Excel - remove non-user folders, sort if necessary to aid checking - add a formula in column B to transform...

Also trying to see what is required to remain compliant from a BP point of view found this link to the Sales Foundation Badge for Planning Analytics: http://www.ibm.com/services/weblectures/dlv/partnerworld/PA_Foundations_Badge The other badges (or at least those I can find) look to be here: https:/...

Hi Wim/bgregs, I have had some inexplicable issues in the past when loading the add-in when Excel start, i.e. configured under the Excel Addins, versus opening Excel then opening TM1p.xla to load Perspectives - From you initial post Wim, sounds like you are loadind TM1p.xla later - is that correct? ...

+1 for VIM - I use it too, especially when editing the .pro files directly.

I would also use some client tools to connect to the database but if you only have TI then use it.

I use the following:
SELECT Table_Name FROM INFORMATION_SCHEMA.TABLES

Should return the tables then you can use:
SELECT Column_Name FROM INFORMATION_SCHEMA.COLUMNS Where Table_Name='<tablename>'

Rtel wrote: ↑

Tue Dec 11, 2018 4:37 pm

...
1) How do I use/setup Notepad++ 7.6 to Edit and Save TI processes. I am not sure how to set up Notepad++ 7.6 for TM1 10.2.2. Its painful indenting TI with space bars in TM1 native editor.
...

If you are looking to indent in TI, try Ctrl+i

Unless the elements that they will select are completely random, you could give users a set of dropdowns/picklists then use these in an MDX query to return the desired elements. Another alternative that I used once was to give the user a list area into which they could select elements - N's and C's ...

Maybe another option is to use Subsets - I have a Current Year on my Year dimension and a Current Month on my Month dimension in one model. I have a cube with a 1 or a 0 for sites to indicate if they are active for publication that period. I can then filter for Sites being active during the current ...

'A' is calculated and unfed again - this will not help you.

Adding Total Rate as a child should help otherwise write a feeder from Total Rate to Rate%

Nudging this one back to the top to see if anyone reading may have insight. Still battling to get PMHUB back but have no idea where to check that it gets started with the rest of PMPSVC, TM1Web and related.

I could be misunderstanding the issue as I interpreted "concatenate" in the context of the images as "wrapping".
In theory, the link I posted should help with the wrapping on the text in "Historico"

Coming in a bite late but saw this again today and thought I would post to see if you had tried or were aware of it.
Wrapping string values in cube views

The only way I have found to do this is to kill the process via TM1Top then kill the associated process running on the database server i.e. the SQL Query/Stored Proc. Until the database releases the query, your TM1 will thread will be locked.

It can work but depends entirely on who you get, their experience and skill level. This is also directly related to their cost. We have come across consultants who could not get the work done or implemented very poor solutions - some of these were very high rates, some low. Because TM1 is very niche...

I tend to agree with Declan - the latency could be down to name resolution, network adapters incorrectly configured etc. I have had both issues before and always check them first. 1) Try running a trace route from both sides to see the path the traffic takes. Does using the IP Address change anythin...

I was working in PAX quite happily until I restarted my TM1 server to install Windows updates. After the update, I cannot connect PAW as PMHub seems to have disappeared. I can still access the pmpsvc and TM1 Web but browsing to "http://localhost:9510/pmhub/pm" gives page not found. I have tried to c...