TM1 Forum

I can create view based on MDX query. And I can after that call this view through REST API. It works fine. But when I try to use this view from API c/c++/basic, then I have troubles. I upload all content of cube. SELECT { TM1FILTERBYPATTERN(TM1SUBSETALL([}Clients]),"*1e4a4f0b688ed8438c7a5c137c3...

Hi, Just a question. I changed the URL to: http://localhost:8000/api/v1/Cubes('CPI')/Views('a')/tm1.Execute?$expand=Cube($select=Name;$expand=Dimensions($select=Name)),Axes($expand=Tuples($expand=Members($select=Name;$expand=Element($select=UniqueName)))),Cells What does it mean if I receive in the ...

Super! I can see that it works! Thank You! I have last problem. When I use API for c/c++/basic and want to extract a content through my new MDX-view from this cube, I upload all content of cube. For example: //cube by name TM1V hCube = TM1ObjectListHandleByNameGet(hPool, hServer, TM1ServerCubes() , ...

Rest API: POST on https://as-msk-a0134:8000/api/v1/ExecuteMDX?$expand=Axes($expand=Hierarchies($select=Name),Tuples($expand=Members($select=Name))),Cells Headers: Accept:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8 Content-Type:application/json; charset=utf-8...

This clause is known to me. And I try to use it like this: SELECT { TM1SUBSETALL([}Clients]) } ON COLUMNS, { TM1SUBSETALL([}Groups]) } ON ROWS FROM [}ClientGroups] where ([}Clients].[Admin], [}Groups].[ADMIN]) However when I use: TM1V hExtractList = TM1ViewExtractCreate(hPool, hObject) and hExtract ...

Thank you. It helps me with mdx-view. I can create a mdx-view, find it and use as regular (native) view. But I can not write mdx-query with restrict by subsets or another condition. For example, I write query: select {[dim 1].MEMBERS} * {[dim 2].Members} * {[dim 3].Members} * {[period].Members} on C...

What did you say about TM1ViewCreateByExpression()? I can call TM1ViewCreateByExpression and get hNewObject. TM1ValType(hUser, hNewObject) == TM1ValTypeObject() TM1ValObjectType(gethUser, hNewObject) == TM1TypeView() and TM1V hParent = TM1ObjectPropertyGet(hPool, hNewObject, TM1ObjectParent()) TM1Va...

How can I select and insert at subset all elements of a dimension whose names match a regular expression? It does not work: TM1V vPattern = TM1ValString(hPool, Pattern, PatternLen); TM1V vOk = TM1SubsetSelectByPattern(hPool, hNewSubset, vPattern,TM1ValBool(hPool, isSelect)); if (TM1ValType(hUser, v...

I need to extract view using filter by an dimension (I have value of an element). I can get/create hView, but TM1ViewExtractCreate(TM1ViewExtractGetNext) extracts all contents of cube.

How can I set an filter? Should I create a new View with subsets?