-
Mapping challenge
Hi I want to build the map with "VILLE", "ADRESSE" items that are in my data set on attached file. But I would like when the user open the map, the map stay only on Lyon city ( Ville).…
- Answered
-
How to call existing formula in a new formula
Hi I have one scenario that is create one new formula as "Pyramid High or Medium or Low" based on values from existing formula. Existing formula name is "Annual Sales" New formula as "Pyramid High…
- Answered
-
calling stored procedure dynamically
can any one suggest how can we call stored procedure dynamically, my actual intention i want to display 52 weeks data using a stored procedure, but in data model i don't want to pass any static…
- Answered
-
How to set Custom Order
I have working on one report and below is my result In above result Physical_Stock columns data suppose to show in below order: 0-30 31 - 60 61 - 90 91 - 120 121 - 150 151 - 180 181 - 360 How can i…
- Answered
-
How to Implement Push Notification
Hi Any one tell that how to create Push Notification in Pyramid Analytics with details.
- Answered
-
Processing Multiple Models vs. One Big Model?
I use a number of Models, each with a specific job to do. A few models pull data into my warehouse from various sources, and a few models abstract different cuts of the raw data suitable for various…
- Answered
-
Pyramid 2020.01 (Service Pack 1) Addressed Issues
Pyramid 2020.01.121 (Service Pack 1) release announcement Bug Fixes Admin Fixed a logging issue related to long MDX field names Fixed an issue where the number of licenses seen in the admin console…
-
Pyramid 2020.01 (Service Pack 1) Released
Service Pack 1 for Pyramid 2020 - build 2020.01.121 - has been released and includes a few new features with numerous fixes. New Features Mobile Timeout - Admins can configure session timeouts for…
-
Page Repeater
Hi, Is it possible to apply the page repeater to a set of pages? I would like the report to repeat page 3 and 4 i.e. pg1, pg2, [pg3, pg4,] [pg3, pg 4].... etc. Regards Linda
- Answered
-
Can you use the same measure twice?
I'm sure I've seen this feature but i cant remember where so. Is it possible to to use the same measure and 2 filters to display different figures on the same axis of a graph.…
- Answered
-
How to remove Grid header deatils
I am showing data on below calculated grid and i don't want to show the grid header in presentation. How can i remove or hide this grid header details ? Regards, Mangesh Desai
- Answered
-
Coloring specific cells
Does PA has coloring option manually. For example if want differentiate negative sales from others
- Answered
-
Using Time Intelligence Hierarchy (Regular) cannot use a separate year filter
Hi I have a hierarchy showing values by year, which then the user can use the regular hierarchy to drill down to quarter, then month then date. Works perfectly however if I add a filter to the…
- Answered
-
Adjust default aggregation for date drill down levels.
I have a calendar hierarchy which when drilled down from Year to quarter aggregates by summing the months in the level below; I like this functionality but would prefer to be able to have it average…
- Answered
-
Pyramid Usage Model
Hi Can someone provide a breakdown of what the usage times relate to i.e. is total time the amount of time someone has used the report in seconds , minutes or hours? What is meant by pre-query,…
- Answered
-
How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics
hi all, I was trying to call an SQL stored procedure from custom query into pyramid analytics in below way. exec dbo.[Get_SalesdetailsPyramid] The statement is valid,…
- Answered
-
How to get # of days between given two dates
Hi, How to calculate data difference by using formulas. Need # days between 2 dates such as "Request Date" was available in source and "Today date". Example :…
- Answered
-
Time Intelligence Intepreting US Date when its UK Date sequence
Hi, I have a date time field formatted as dd/mm/yyyy hh:mm:ss Sample 21/09/2019 00:00:00 But Time Intelligence is interpreting is as mm/dd/yyyy hh:mm:ss Server System time has been checked as UTC…
- Answered
-
Failed while creating Formula
I am facing below issue while creating formula for particular column. failed run sql query in model source. model: SELECT SUM([_AddInfosMoves_Allowed_].…
- Answered
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
Enabling access at Folder Level in Public Content
It would be good if we have an option to enable the access to specific folder in Public Content at folder level. At the moment it can only be enabled at object/report level,…
- Answered
-
Can Admin see which reports Users have accessed?
Hi, Can the admin account see which reports specific users have accessed? Often times client users will ask me questions, but I don't know which report they've looked at specifically.…
- Answered
-
Can't log in to pyramid?
If you have configured your Pyramid instance to use Active Directory (AD), and hear that users intermittently cannot log in, check the following, The reason might be that your LDAP address sometimes…
-
Publications with Discoveries across pages?
HI, I have a Discovery with a number of charts that in a publication will go across multiple pages, how do you paginate a Discovery in a Publication?
- Answered
-
Getting Started with Pyramid
In our first session, we will cover the basic getting started workflow from Quick Model, to Discover and finally Present. These examples are simple and designed to acquaint you with the product.…
Welcome to the Pyramid User Community
Pyramid User Community