-
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
-
data retrieval
Hi all.... I have a query while making some modifications to my existing report My requirement is: 1. Have the stored procedure (with @year and @weekno parameters) to display weekly wise report for…
- 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
-
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
-
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
-
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
-
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
-
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
-
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 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
-
Calculate difference from two table on presentation
I have below two table on presentation and I want to calculate difference between Grand Total. Please See below screen shot:
- 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
-
map customization
Hello everybody. I'm asking if it is possible to change the by default coloured circle for dimensions put on a map. I'd like to point on a map adresses in a city.…
- Answered
-
Conditional Formatting
I have been converting reports from BI Office to Pyramid 2018 and I have run into a snag. Note that this report was imported from BI Office to Pyramid 2018 using the conversion tool.…
- 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
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
Model running but no discovery building
Hi we've just upgraded to 2020, and looks great! however when I'm running a model built in prior version it runs through perfect and says no issues but it won't load up the discovery for the model?…
- Answered
-
Roles lost and KPI's not working after update to 2020
Has anyone else experienced the loss of their Role settings in the Admin console after updating to 2020? Did anyone lose (present, but not functional) their KPIs after updating to 2020?…
- Acknowledged
-
Connecting multiple Excel selections to Python script 'easily'
I want to use an existing Python function to do calculations on my data in an Excel file in Pyramid. The script uses multiple inputs from the Excel file,…
- Answered
-
URL Too Long when using an action to drive to another report.
Hello I've created a report which I want to use as a detail report. I create an action so that summary reports can drill down into the detail report using "cell".…
- Answered
-
Sqoop import to HCatalog/Hive - table not visible
HDP-2.4.2.0-258 installed using Ambari 2.2.2.0 I have to import several SQL Server schema which should be accessible via Hive, Pig, MR and any third party(in future). I decided to import in HCatalog.…
- 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
-
Filter Slicer content based on existance of measures
Hello, I want to create a slide in Pyramid which shows a table with a measure sales of the 12 last months. The measure Sales is connected to a dimension hierachy (Organisation: subteam, team,…
- Answered
-
Adding more than one hierarchy level to a discovery
Is it possible to include more than one level from a hierarchy in a discovery? I need to show both City and State but as they are in the same multi-level hierarchy I can't add both.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.