User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Latest Posts
Re: HR Cube - Absenteism hours - Formulate
Hi Nosika, If you have a SSAS cube. You cant use a script like this to calculate for each row with value on Absence column : iif(isleaf([Personne].[Nom Complet].currentmember), iif(isempty([Measures].…
Laurent Jamet
Laurent_Jamet.1
2 mths ago
Q&A
Reported - view
Re: Replace a null attribute by another not null
Hi Yakov, Off course, If attribute label of column 1 is Unknown, the conceptor would like replace it by the label of the column 2. However I don't think is-it possible. Thanks
Attachment
Laurent Jamet
Laurent_Jamet.1
2 yrs ago
Q&A
Reported - view
0
Replace a null attribute by another not null
Is there a way to replace one null attribute with another (see attached)? I think it should be done in the cube, maybe... Thank you. Laurent
Laurent Jamet
Laurent_Jamet.1
2 yrs ago
3
replies
32
Q&A
Answered
Answered
0
List Variable in a Model
Hi, i created an model with a single value variable, it works perfectly. But when i change my variable into a list, my query finds no row. I think i don't use the good syntax.…
Laurent Jamet
Laurent_Jamet.1
3 yrs ago
1
reply
42
Q&A
Answered
Answered
Re: Using Python or R to pivot excel workbook
Hi Nick, An exemple of unpivot function with Python : import pandas as pd data =pd.DataFrame({'Etab':Param1,'ADM': Param2,'LOG': Param3,'EDUC':Param4,'MED':Param5,'SOIN':Param6}) OutputDF=data.…
Attachments
Laurent Jamet
Laurent_Jamet.1
3 yrs ago
Q&A
Reported - view
0
Discovery filter in URL
Hello I can filter a discovery with a filter in the URL, but I need to select all the members from my list, how do I do this? Thanks
Laurent Jamet
Laurent_Jamet.1
3 yrs ago
1
reply
24
Q&A
Answered
Answered
0
CurrentPeriod & StrToDate in an InMemory Model
Hi, I created an InMemory model in which i have Date elements. When i try to use CurrentPeriod or StrToDate functions, syntax control is ok but result is empty,…
Laurent Jamet
Laurent_Jamet.1
4 yrs ago
1
reply
35
Q&A
Answered
Answered
0
Join Options in Model
In version 2018-03, I can't no more using Left Join, Right Join or Outer Join, just Inner Join is available. Is it a definitive choice ?
Laurent Jamet
Laurent_Jamet.1
4 yrs ago
1
reply
31
Q&A
Answered
Answered
Re: Send a publication in attachment
@Itamar Birenzweig Hi Itamar, We've got a enterprise license, is-it not included? I will contact Herbert to obtain more details. Thanks
Attachments
Laurent Jamet
Laurent_Jamet.1
4 yrs ago
Q&A
Reported - view
0
Send a publication in attachment
when i perform a Scheduled plublication by mail, i recieve correctly the mail notification. Is-it possible to send publication in attachment ? Thanks
Laurent Jamet
Laurent_Jamet.1
4 yrs ago
2
replies
37
Q&A
Answered
Answered
Re: Condition Or / And in Model Data flow functions
Perfect, thank you.
Laurent Jamet
Laurent_Jamet.1
4 yrs ago
Q&A
Reported - view
0
Condition Or / And in Model Data flow functions
how can i apply a condition Or / And in calculation column ? this syntax generates an error : if([Test_CP] !=="P" or [Test_CP] !=="F" ,"Chambre double","Chambre particulière") This one too :…
Laurent Jamet
Laurent_Jamet.1
4 yrs ago
2
replies
30
Q&A
Answered
Answered
Laurent Jamet
Laurent_Jamet.1
France
26
29
2
Joined: 16 Jan 2018
Follow
Groupe LEADER
France
https://www.linkedin.com/in/laurent-jamet-aa894569
Home
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help