TM1 Forum

Update:

Instead of extracting data to a file a decision was made to present data as a view for user. I ended up removing all the codes related to data extraction and data source specification.

Thanks to all.

Kenneth

Thank you! Will try.

ascheevel wrote: ↑Fri Dec 13, 2019 9:02 pm For your test cube, your MDX should look something like the below. I'll try to take a look at your other posted code this weekend.

Code: Select all

ViewCreateByMDX('Cube', 'View',
	'select {[Dim1].[1]} on 0,
	{[DimA].[A]} on 1 from [Cube]'
	);

Hi, I was only testing with a test cube with test dimensions, it was like: ###### ViewCreateByMDX ( 'Cube', 'View', ' { [ Dim1 ] . [1] } , { [ DimA ] . [A] }' ); ###### Below is the MDX expression for the dimensions subject to the view that I wanna export. ############################## vIndexDim = ...

Thanks and I'm actually on PA 2.0.7. I'm trying to research to use ViewCreateByMDX but the statements couldn't figure out the syntax yet for a MDX view. In the mean time I'll probably having a TI for the user that they can name the view and access it then take a snap shot. Thanks! Kenship, is your u...

Thanks Steve. I tried following your instructions and added a SubsetMDXSet function to remove the MDX. It converts the subset to be static but the export still lists the elements using index order. Basically in my Prolog I created the temp. view and subset then used a WHILE loop for all the dimensio...

An update: now I found this thread: https://www.tm1forum.com/viewtopic.php?t=10604 .

I noticed Tom saying to "do your own walk through the subsets in the Prolog tab using CellGetN and ASCIIOutputs inside WHILE loops".

I wonder what it means.

Hi, I'm trying to get TI to extract data based on a subset that is sorted according to project value based on criteria chosen by a user. I used MDX to sort the project dimension based on the selected criteria and is working. However, when using AsciiOutput I noticed data is sorted based on dimension...

To name just 1 thing, I would expect to see TM1SubsetAll of DimC not of Cube. Ouch! You're right Wim. I figured it out. Here's what works for me: { ORDER ( { TM1FILTERBYLEVEL ( {TM1SUBSETALL(DimC)} ,0 ) } ,[Cube].( [DimA].[(ALL Dim A)] , [DimB].[(All Dim B)] , [DimD].[(All Dim D)] , [DimE].[$] ), B...

Hi, I'm reading and testing to use MDX Order function to sort dimension element based on cube value. I think I got 80-90% but Expression Window in Subset Editor still gives me syntax error. Here's information: Cube Name: Cube Dimensions: DimA t0 DimE (with "$" being the measure in "Di...

Thanks Tom!

Will definitely try that.

Kenneth

Hi, Basically we have different department users and we restrict user access to their own department. However some presentation objects require user getting total amounts for other departments. At this point we do not want to change security access. Therefore we are thinking whether a TI process can...

Dear all, After upgrading from 10.2 to PA we now employs Azure OpenID for user authentication instead of Active Directory. From what we know there's no way to setup CDM (10.3) to connect to PA as data source using Azure. For now all we can think of is to create a non-SSO server for CDM connection an...

Hi, I have report cubes that were created in 10.2 and randomly give me error as the following. There's no rule nor process related to these cube any more. Any idea is appreciated. 3472 [27] ERROR 2019-03-11 14:52:40.337 TM1.Cube.Commit CubeDataVersionCreateExData_t::handleLeaf: Simple cell [10,4,3,1...

Interesting. I will test. 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 formul...

Hi, We are changing from Active Directory to Azure. As a result the user folder created to store private view and subset are changed from: Last Name" ,"First Name To First Name" "Last Name I wonder if there's any quick tool that can help rename folder instead of copying and pasti...

Agree! It's a good solution.

Thanks Paul!

My experience was that the problem was there earlier than 2.0.5. We upgraded to 2.0.4 and immediately was the biggest issue. Our server was new and therefore MTFeeders was on and we didn't notice. I asked the question back in Oct here and no one seemed to have a clue. Any way I worked around by rewr...

Thanks but unfortunately it still put Net Profit down at bottom. I began to believe that since the elements expanded are coming from the same parent (Net Profit) that I want to place on top, the Expand Above overrides and put it at bottom no matter what the MDX said. Kenneth Hi Kenneth The following...

I'm building a subset using MDX. The hierarchy structure looks like this: Net Profit > Gross Exp > Exp Group > GL Accounts > Revenue > Rev Group > GL Accounts The request is to list all of them to the lowest level but using Expand Above so that subtotal at the bottom, except Net Profit to remain on ...

Our consultant forwarded an alert from IBM this morning regarding MTFeeders. https://www-01.ibm.com/support/docview.wss?uid=ibm10742569 Basically, MTFeeders should now be turned off in TM1s.cfg file until it's sorted out. When I transit from 10.2 to PA 2.0.4, this is the first major problem. We crea...